How to import an Excel range into Word mail merge docs using Office 2003

lilynet

New Member
Joined
Jun 9, 2008
Messages
7
I am currently producing reports for hundreds of individuals using mail merge to modify fields such as name, ID#, and locations for each report. I then go in to each document to paste an excel range as a bitmap that is specific to each individual/report.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p> </o:p>
The excel range comes from a unique excel file for each individual that is saved by the same ID# that I use in my mail merge data source. The range that I select is identical in each file, eg: "A1:U68".
<o:p> </o:p>
Is there a macro or another method I can use to automatically select, copy, and import the excel range as a bitmap into my mail merge documents by matching the ID# in my source data to the filename and filepath (all the excel files are in the same folder).


Thanks very much!!
 

Forum statistics

Threads
1,085,249
Messages
5,382,573
Members
401,795
Latest member
Ginger12

Some videos you may like

This Week's Hot Topics

Top