We help IT Professionals succeed at work.

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

PPJoseph
PPJoseph asked
on
Medium Priority
354 Views
Last Modified: 2012-06-27
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.
Comment
Watch Question

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

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
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
.

Commented:
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.

Author

Commented:
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.