Send report vie e-mail

[sabavno]

Hi

I am looking for the code to send a report through e-mail or export to the Word file.

Thanks

 

[samuelebennett]

How about using the sendobject syntax:

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

 

[evalesthy]

You should look at SnapShot Viewer (available free as MS download if you don't have it). It allows you to save a report with all formatting intact (lines, graphics, and other embedded objects, etc.)that get stripped out if you save as text file. It is similar to saving as a pdf file in Acrobat. Keep in mind the recipient must have Snapshot viewer also. See

http://www.microsoft.com/accessdev/articles/snapshot.htm

 

[UrbaneRove]

Just another follow up of an interested on-looker.

This example assumes that there is an e-mail client on the computer running the vba.

Can anyone direct me to how to do the e-mail if the computer has no e-mail client or even if the client is not configured.

Thanks

UrbaneRove

 

[UrbaneRove]

Found a link on this issue

in the vb 6 forum

thread222-48543