Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2004

Tip: Looking for answers? Try searching our database.

Multiple Word Documents On Excel Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Johnmichael Monteith - 29 Jun 2004 18:41 GMT
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
Dennis - 29 Jun 2004 19:58 GMT
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

>-----Original Message-----
>I have a bit of a puzzle that I hope someone can help me with.  I believe
[quoted text clipped - 19 lines]
>
>.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.