Splitting Query Results into Separate Excel Files to be E-Mailed

[smiley1978]

How would I split the results of a query, by an ID field, into separate tables or dynasets, that can be attached to e-mails as Excel files? My end goal is to run a macro, the macro separates out the data into their respective Excel Sheets and then attaches them to e-mails.

I have a table that has the e-mail address and an ID number that ties back to the table that stores my data.

I have attached files before, but I have not split them out across multiple emails with separate files for each e-mail.

 

[Micron]

Did you consider the Docmd.SendObject method? You can send the results of a query, based on a criteria field, as one of several formats, including workbooks. If you have several to do as a batch, you'll need to use a recordset of ID's with email addresses and loop through each record, using the ID as sql criteria and the email address of that recordset as the recipient. You can then send the specific records for a given ID to the applicable recipient(s).

I use vba almost exclusively and don't use macros, so I can't tell you what the equivalent steps would be. Hope that helps a bit.

 

[smiley1978]

Thank you. I have done that in the past and I wasn't sure if there was a better way or not.