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.

cheers

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.

Gr.

Cyriel

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.

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.


thanx

Ah you want a link to the snapshot file which resides on a website?

Cyriel