(Msg. 2) Posted: Mon Feb 04, 2008 9:16 pm
Post subject: Re: mail merge using two data sources [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Mail Merge is only designed to use a single data source.
What to do if you have more than one depends at least in part on
a. what the relationship between the two data sources is, and what you are
trying to produce (e.g. are you doing a "one-to-many" merge where one data
source has one record (such as "Customer") and the other has multiple
records for that Customer? Or do your two data sources each have one record
per Customer (or whatever)? Or maybe you have a main data source and you
need to pull in a couple of items from somewhere else, in which case
http://tips.pjmsn.me.uk/t0004.htm might help)
b. what the data sources are, and the options available for joining them
together. e.g. you can do some stuff with Excel workbooks and tables using
the Access/Jet driver/provider and some SQL. Or you can write code to turn
your two data sources into a single data source. Or you can do the same
thing manually before mergeing.
c. whether you can use Word VBA and Word's Mailmerge events to do what you
"Nathan" wrote in message
> How can i insert data from two different Excel files into the same mail
> word document?