Mass Email from a Query

  • Thread starter Thread starter janschutz
  • Start date Start date
J

janschutz

I have a table with vendor no and email address and I have a query with a
parameter for which vendor no I want. How can I create a mass email using
the table and the query.

Thanks
 
Let me add some additional information. The process that I need to create is
to send an Excel file of the data from a query. That query had an ask
parameter for each vendor # that I need to send an Excel file to. I have a
table with the vendor information. The process that I am using now each
vendor has a separete query such as M16100 and I have a multi line Macro runs
each query to an Excel file an emails the information out. Currently there
is only twelve vendors but this will be increasing many fold. I want to use
just one query and the vendor table to send all the Excel files out. Each
Excel file has each vendor data on it.
 
Back
Top