Send Query Results as attachment to an Outlook Message

[lizzycole]

I am attempting to set up a query that can be run and sent as an attachment to an Outlook message. I am prepared for several steps to do this. My first thought is to export to Excel first, but if I can maintain everything in Access, I would like that better.



Note: The query referenced here is just a shortened version of one of my tables. I did not want to set up anything more complicated if this isn't going to work.

My Goal is to:

1. Run the IronMountainSDL query
2. Save the results as a .csv
3. Attach to a mail message
4. Send mail message to static recipient list
5. All automatically if possible

If you care to review my database to provide any other feedback, it would be appreciated.

Push-Release Tracking - Copy.zip

[June7]

See if the SendObject method meets your requirement. http://office.microsoft.com/en-us/ac...001226290.aspx