Mass Email from a Query

[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

 

[Ryan Ramos]

Not sure if someone already responded to you.
You may user MS Word Mail merge function.

See http://www.contextmagic.com/express-clickyes/ if you want to avoid
always click yes when MS word trying to send data on your MS outlook.


--
Ryan Ramos
IT Operation Technical Specialist


"(e-mail address removed)"

 

[janschutz]

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.