Mail Merge with many data sources

G

Guest

I am trying to use the mailmerge function of Microsoft Word. I have a MS
Access data source with 5 or so tables in it. I am trying to use data from
those 5 table and combine it into one letter i am creating in MS Word.

My question is, is it possible to add many data sources and not just one??
Because when you click on the button that says "Open Data Source" it only
allows you to select one and the information i am trying to include in my
letter is contaned in a few data sources. Please help..

Thanks.
Mark
 
D

Doug Robbins

You can only use one data source. Use a select of union query in Access to
combine the relevant data from each of the files into one "flat file" that
can be used as a mail merge data source.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with mail merge using Access Database as source 1
mail merge/labels 2
Location of "My Data Sources" 1
Mail merge date format 1
Mail merge with Outlook contacts 1
Mail merge source 7
MSWord mail merge 0
forms, data import excel, generate multiple pages 2

Top