asked on

Export a report with text, line and boxes to MS Outlook

I set up a send object function to send a Report generated in MS Access 2000 to MS Outlook for emailing. The report has lines and check boxes for yes/no. It looks perfect in preview but when exported to email the lines and boxes are left behind. The text is transferred to email perfectly. I used the rich text format. Is there a way where the lines and boxes can also be transferred along with the text to the email.

walterecook

I'd create a snapshot first
DoCmd.OutputTo acOutputReport, "rpt_E_Mail", "Snapshot Format", someFileName
then email that as an attachment
Your recipient must have the snapshot viewer, but it is a free utility.

Walt

SOLUTION

JohnK813

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Quetzal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Quetzal

WRT John's suggestion....

Here is a basic approach. Design a Word mail merge document that looks the way you want it to. Using Word automation, open the mail merge document, creating a new, merged document. Using the SendMail method of the ActiveDocument, email the merged document.

These references may help:

create a form letter for mail merge:
http://support.microsoft.com/default.aspx?kbid=212329&product=wrd20

automate mail merge from Access:
http://support.microsoft.com/?kbid=209976

using Access as a data source for mail merge:
http://support.microsoft.com/default.aspx?kbid=211190&product=wrd20

where to find info on Word object model:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;222101
.

JohnK813

Thanks for helping with the links, Quetzal. I like the idea of creating a PDF, since that way the user can't modify anything.

PPJoseph - if you want to go the Word Mail Merge route, let me know and I can show you a code outline.

PPJoseph

ASKER

Quetzal: I'll go the PDF route as the report will not be modified. John I appreciate your idea of word merge but I'm sure you will agree that it cannot beat pdf format. Hope I'm not making a case for Adobe. Thanks all