email a report with images embedded (1 Viewer)

[BarryMK]

I have a report which has a different picture for each record. Using 4 different types of command button syntax that I found here I've been able to send the report successfully as an email attachment but the images are blank.

I presume this is because the jpgs are stored in a file folder and linked to the database.The image holder in the report is set to embedded but this makes no difference.

Is there a way around this problem?

 

[HiTechCoach]

What format is the attachment? Are you using a Snapshot file?

 

[BarryMK]

What format is the attachment? Are you using a Snapshot file?

Hi Boyd

The attachment is rtf. I'm not familiar with snapshots and the recipient of this email is computer illiterate so I need to make it as easy as possible to send him the information.

Barry

 

[BarryMK]

Thanks for the pointer Boyd. I looked up snapshots here and using the code below it works a treat. Cheers.

Private Sub cmdEmail_Click()
DoCmd.SendObject acReport, "rptDS", "Snapshot Format", "Your email recipient", , , "EMAIL SUBJECT", , False

End Sub

 

[John Big Booty]

You may find that your email recipient can not open a snap shot report, however there is a free viewer available for download here

 

[BarryMK]

Thanks John.

 

[gemma-the-husky]

you can easily do a pdf also - good pdf generator around (is it courtesy steven lebans?)

 

[John Big Booty]

....and if you are on Access 07 there is an add in to allow creation of PDF reports

 

[BarryMK]

We're on 97 and 2003 here and the recipient's kit is an unknown quantity at the moment! The snapshot option works fine and is simple so I think I'll stick with that subject to the recipient being able to install the viewer and to ms PITA security dialog hassles.

Thanks for all your suggestions. As Arnie put it -"I'll be back!"

 

[Mike375]

you can easily do a pdf also - good pdf generator around (is it courtesy steven lebans?)

Yes

http://www.lebans.com/WhatsNew.htm

PDFCreator is good but is not self contained and you can't do anything with it. With Leban's you can do a whole lot with it because it is a DB. You simply use his modules, but I stopped the part that opens the PDF converted Report, don't bother with his form/activate system and then add your "bookends"