Question Sending customer stock report by email

[Lanason]

Hi Guys,

I want to send a stock report to a number of customers. But I dont want loads of reports and queries. Is there a simple way I can define the "send to" email addresses and then use the same report for each customer with a variable in the query to select the relevant data.

I am currently using a macro / query / report for each customer

 

[pbaldy]

One way:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

Another would be basing the report on a parameter query.

 

[Lanason]

One way:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

Another would be basing the report on a parameter query.

Thanks for the Report bit, but how do I customise the email addresses

 

[pbaldy]

Not sure what that means. Did you see the link to the looping code? Somewhere in that code would be

Forms![Select Load List]![LoadID] = ValueFromRecordset