I currently have a word macro that will save a unique file for each mail merge record. However, I'd like to expand on this and have certain excel tables/charts pasted into each of these files. So I am thinking I can do the following - all in excel - but would like feedback before I start just in case it isn't possible.
Initializing the macro from the excel file
-open the word document template
-connect the mail merge database file
Unique coding for each record due to the charts/graphs being unique to each file:
-perform mail merge in the word document for record X
-copy the table from the excel document
-search word document and find/select placeholder text for the table
-paste-special image
-copy graph #1 from the excel document
-search word document and find/select placeholder text for graph #1
-paste-special image
-copy graph #2 from the excel document
-search word document and find/select placeholder text for graph #2
-paste-special image
-update table of contents
-save file
Initializing the macro from the excel file
-open the word document template
-connect the mail merge database file
Unique coding for each record due to the charts/graphs being unique to each file:
-perform mail merge in the word document for record X
-copy the table from the excel document
-search word document and find/select placeholder text for the table
-paste-special image
-copy graph #1 from the excel document
-search word document and find/select placeholder text for graph #1
-paste-special image
-copy graph #2 from the excel document
-search word document and find/select placeholder text for graph #2
-paste-special image
-update table of contents
-save file
