Multiple Word Documents On Excel Mail Merge

  • Thread starter Johnmichael Monteith
  • Start date
J

Johnmichael Monteith

I have a bit of a puzzle that I hope someone can help me with. I believe
this can not be done with Word / Excel, but maybe someone knows a solution,
or knows a third-party add-on that would do the trick:

I have an Excel spreadsheet with mail merge fields, and in one column I was
thinking it would have the filename of the Word document to merge with.
Ideally, it would pick a template, and merge with that document. So,
basically, I want to do a mail merge from Excel into multiple Word
documents.

I am aware of the ability to use AutoText / IncludeText to hardcode
mergefields into "Letter1" and "Letter2" in a document. But, that will not
work due to variety of Excel documents that will be used and the varierty of
templates that are being merged to.

If anyone has some ideas, it would be very much appreciated!

Thank you.

jp
 
D

Dennis

Write an app in VB to open the sheet and spin thru the
cells. You can suck in the cell contents, and then open the
appropriate Word doc.

Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merge Excel file into Word Document 3
Start a mail merge upon opening the document 1
Embed the same Excel multiple times 0
Mail Merging into PowerPoint 0
Integrating information from Word to Excel (not mail merge) 1
Mail Merge 1
Email Mail Merge via linked Excel sheet 0

Top