Individual Emails and Attachments from Form

[DBL]

I'm sure this is here somewhere but I just can't find it.

I have a form where a selection of suppliers are selected, I then want to email each supplier a report attachment - headed up with their particular details - for them to complete and return.

I can use the SendObject to send one email with all reports attached, how do I split it up? Can I split it up?

 

[MickC]

If I'm understanding the question correctly you can use a query to filter the data by supplier and a parameter form to launch your report (email) based on the result of query. On the parameter form you type or select the supplier name, you will need a command button on the parameter form where the OnClick event is set to launch the report and off you go. You can do this through coding or as I do, being a novice at VBA, by using macros and building the event. I hope this might help. I do similar and use the EmailDatabaseObject as PDF to export it to outlook ready for sending. Which leads me nicely on to my own question, which I will post shortly.