ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   mail merge multiple lines in an e-mail (https://www.excelbanter.com/excel-discussion-misc-queries/249614-mail-merge-multiple-lines-e-mail.html)

Guy[_2_]

mail merge multiple lines in an e-mail
 
How can I merge multiple lines from an excel document into one e-mail ?
So the e-mails should be dynamical.

macropod[_2_]

mail merge multiple lines in an e-mail
 
Hi Guy,

There's probably an Excel vba solution for this, but there's also a Word mailmerge/vba solution using Word's Catalogue/Directory
Mailmerge facility (the terminolgy depends on the Word version). To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.


--
Cheers
macropod
[Microsoft MVP - Word]


"Guy" wrote in message ...
How can I merge multiple lines from an excel document into one e-mail ?
So the e-mails should be dynamical.




All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com