Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jun 2004
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Microsoft Office Access can't send this format... (Access 2003 & Outlook 2

    Has anyone else tried using the following command (or similar) in an Access 2003 database, to automatically generate and e-mail an html document using Outlook 2003, but which causes the error "Microsoft Office Access can't send this format in a mail message" ......

    DoCmd.SendObject acSendReport, DocName, "html"....

    Office 2003 Service Pack 1 doesn't solve this problem. The command works perfectly with Access 2000 and Outlook 2000. Does anyone else have any suggestions?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Microsoft Office Access can't send this format... (Access 2003 & Outlo

    You have to use uppercase for HTML :
    DoCmd.SendObject acSendReport, "Namen", "HTML",...

    or the vba constant acFormatHTML :
    DoCmd.SendObject acSendReport, "Namen", acFormatHTML,...
    Francois

  3. #3
    Lounger
    Join Date
    Jun 2004
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Microsoft Office Access can't send this format... (Access 2003 & Outlo

    Thanks very much Francois, I'll give it another go...!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •