Attach a MS Access report to email generated by VBSendMail

[jlitondo]

Hi everyone,
Is there a way to directly attach a MS Access report to an email generated by the VBSendMail dll without first saving it to a directory?
The dll requires that a file/report be saved on disk before it can be attached but it would be nice to directly attach the report from access without first saving a hard copy of it.
Anyone done this before? Thanks.

 

[jlitondo]

I doubt that it is possible to attach a ms access report to an outgoing email without first saving it to disk using this method. If you use outlook as the mail client, then it can be done.
However, the other thing that can be done is to dump the report's data directly to the outbound message, either by first saving it to a temporary table or by fetching the data directly. You would have to predefine the output formating yourself somewhere in your code.

 

[jlitondo]

One other thing, if saving the report to disk is the way you go, and if running across a network, you may have to use win api's to figure out the current user login, and then either create a sub directory under it or save the report in his/her root directory. You'd have to test this first too since network permissions may become an issue.

 

[MakeItSo]

It is possible if you use this code:

DoCmd.OpenReport "yourreport", acPreview, "", "yourfilter"
DoCmd.SendObject acReport, "yourreport", "RichTextFormat(*.rtf)", "", "", "", "yourmailsubject", "", True, ""

DoCmd.Close acReport, "yourreport"


MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[jlitondo]

Hello MakeItSo. Your code would only work if you are using Outlook as your mail client. But I am bypassing Outlook all together and using the vbSendMail app which works great except when it comes to directly emailing a report from access the way your code would do.

 

[jlitondo]

Actually I figured that using sendObjects would save the report to a temporary folder behind the scenes then delete it after attaching it to the email.