[swicklund]

I have a several buttons set up on a form that will automatically set up various reports to be mailed in a .snp format using the command:

DoCmd.SendObject acReport, stDocName, acFormatSNP

What I would like to do, is send multiple reports w/ one email. When I try putting this command multiple times in the code for a button, then it sets up the emails, one after the other.
Any thoughts???

[Advertisements]

http://www.utteracce...amp;type=thread <---this article seems to suggest that you cannot do this with the sendobject function...it has a few options for other methods

[dsenette]

http://www.utteracce...amp;type=thread <---this article seems to suggest that you cannot do this with the sendobject function...it has a few options for other methods

[lurky]

Swicklund, I'm not really sure what kind of environment you're using or the actual platform involved. But you might try to work something out with the MS Word mail merge feature. I'm pretty terrible with code, so I'm not even sure you could automate it.

Also, do you have a sharepoint server available? You put the database on the sharepoint server and set it up as a data source for an infopath form, which I know you could automate. You're obviously far, far over my head in terms of writing code so I don't really have anything to help you out with in terms of actually automating it. Just kindof tossing in some logistics in case you hadn't thought of them.