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 / January 2008

Tip: Looking for answers? Try searching our database.

E-mail merge of Word and Excel documents...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Heitmuller. - 23 Jan 2008 14:12 GMT
Does anybody have any conceptual guidance on how to handle this e-mail
merge scenario?

I am starting with two documents an Excel Spread sheet containing
client statements and a Word document containing personalized
statement cover letters.  The Excel spreadsheet has one client
statement on each tabbed worksheet.  The Word document has one
statement cover letter per page.

I need to perform an e-mail merge that e-mails the matched statement
and cover letter to the appropriate e-mail address.

Anybody got any advice on how to approach this?  Is there any off the
shelf software that can handle this?

Thanks,
John
Peter Jamieson - 30 Jan 2008 18:26 GMT
I guess you probably made your decisions, but...
a. I don't think there is any simple way to do it
b. Assuming that there is a simple (1-1?) correspondence between the Word
documents and the Excel tabs, I would probably keep it simple and write code
to split the Word document and the |Excel workbook into their constituent
parts and take it from there.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Does anybody have any conceptual guidance on how to handle this e-mail
> merge scenario?
[quoted text clipped - 13 lines]
> Thanks,
> John

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.