May 20 2005, 05:20 AM
I am using a script to send my reports by email and they are sending the reports in rich text format, i have noticed that the logo i have at the top of my reports isnt included when i send the report as an attachment, is it because of the format i am sending them or something else
DoCmd.SendObject acReport, "Alarm Activation", "RichTextFormat(*.rtf)", "", "", , "Alarm Activation", "", False, ""
This is the format at the moment what format will show the logo.
May 20 2005, 07:22 AM
Yes thats because of the format you are using. Images are not exported to RTF in MS Access. If you want to also incluse the images of your report than you'll have to use the Access snapshot format with your export. The disadvantage of this is that your end users which will receive the email must use MS Access Snapshot Viewer to see the report. You can download snapshot viewer from microsoft.com. Snapshot Viewer is also included in MS Office.
P.S. Of course you can also export a report to pdf and send that with the mail, therefore you need a PDF Printer to print the report and attach it to an email with the MS Outlook model which is available in VBA environment.
May 20 2005, 08:09 AM
ok thanks for that ive used the snapshot format works a treat.
i was wondering how would i include a link within the email that i am sending the snapshot attachment, to link to a website, so each time i send this email it has a link atached.
May 26 2005, 09:07 AM
Ah you want a link to the snapshot file which resides on a website?