How do I mail merge data from different Excel worksheets into one.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have three seperate Excel files (version XP) and I would like to be able
to use one Word document (version XP) that will mail merge from the three
Excel files. The reason for the three Excel files is because I have so many
variable names that it does not fit into one file. Is there a macro that I
may be able to ue that will allow me to do this? Thank you.
 
Hi =?Utf-8?B?Ymx3?=,
I have three seperate Excel files (version XP) and I would like to be able
to use one Word document (version XP) that will mail merge from the three
Excel files. The reason for the three Excel files is because I have so many
variable names that it does not fit into one file. Is there a macro that I
may be able to ue that will allow me to do this?
Click to expand...
Mail merge cannot work with multiple sheets. If by "variable names" you mean
field names (columns), then your only chance would be a delimited text file, as
far as mail merge is concerned.

Other than mail merge, there would be the possibility of using VBA to automate
Word and insert all the information, one document at a time. To get a start on
this, you should find an article on automating Word from within Excel (and vice
versa) on the word.mvps.org website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
Back
Top