Sending Email with an attachment report that includes pictures in Access.

[Fred's]

Dear All,
I've built a database to track supplier shipment problems. In my
database I have a table with supplier detail, a form which I
am selecting date, add problem ect... and a finally a report which
gather the information from my table to send to supplier. All looks to
work perfectly, but now I would like to add pictures into my report in
order to show the supplier the errors.

How can I add and send pictures to my suppliers? Any codes will be
welcome...

Any suggestions,

ps. You can either respond to my message to this group or to:
(e-mail address removed)

Thank you all for your help!
Fred's

 

[Greg Helmbrecht]

Hi,
The best way I have found to do this is build a macro.
Pick "SendObject" from the list under "Actions". Then go to your "Action
Arguements" below and choose "report" from Object Type line. In the next line
you can identify which report you will be sending. Output Formats you may
have to mess with depending on who will be viewing your reports but I find
Rich Text Format the best.

To: You can specify who you are sending to here or leave blank and enter it
when the email pops up.

Use a command button on a form that runs the macro and you should be in
business.

Pictures tend to take up a very large amount of space, think carfully about
how many of these files you will actually be keeping in the DB and consider
pointing to them instead of having them part of the DB.

Hope this helps.