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
fficeffice" /><o> </o>
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> </o>
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!!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>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
> </o>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!!
