Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each Record Emailed?

gmayor · #1 08-05-2016, 08:46 PM

If you have read my 'stuff' then you should have seen http://www.gmayor.com/ManyToOne.htm . That will merge many rows to one e-mail either as an attachment or to the message itself as you appear to be describing. It works best if you use a table to format your document, with or without table borders as with the supplied example.

Sgt Rock · #2 08-08-2016, 05:21 AM

Quote:

Originally Posted by gmayor

If you have read my 'stuff' then you should have seen http://www.gmayor.com/ManyToOne.htm . That will merge many rows to one e-mail either as an attachment or to the message itself as you appear to be describing. It works best if you use a table to format your document, with or without table borders as with the supplied example.

Monday Morn - had the grandkids over this weekend, so my apologies for just now replying. OK, I will admit when I began to read your article it seemed to me it was merely an advertisement for an add-in, so I sat it aside. This is the one that is 33 pages. However I will check the link you sent to see if it's the same article or different.

I am elated to hear mulit-row messages can be done with an email vs having to attach a document to an email which I hate to do for so many firewalls will strip off the attachment. I see you or someone added some additional links to view - THANKS. Maybe the system did it? While I think(?) I'm programming savy, I grew up in grad school in the ole Fortran IV days, and now VBA, but I struggle with object oriented programming for some reason, how to actually "program" Word field codes to do what you want is still eluding me. Let me read some this morning Graham. Thanks for your assistance and advice in advance. Mort in Dallas, TX

Sgt Rock · #3 08-08-2016, 05:23 AM

However, this time I will read more thoroughly and respond accordingly. Thanks Graham.
Mort

Sgt Rock · #4 08-08-2016, 06:04 AM

I must admit Graham, you are far more advanced than I in understanding all this complex issue.

Your instructions are most detailed for your Add-In, but, this is just me now, I am not after how to use an Add-In.

I want to be able, myself, to use Word Field Codes to perform an email merge using Word as the source document, Excel as the data source (Table as you suggest), and Outlook as the conveyor of the email messages. I am adept at sending one to one, i.e., one record = one row in Excel. However, in my situation now, each facility (record) has multiple rows of information, i.e., chemicals. If the facility only had one chemical, "piece of cake" - can send those out all day long. Although I do not want to do this, it may be easier to create individual Word documents for each facility and send as an attachment to the email?

Your expertise is admired.
Best week's wishes,
Mort in Dallas

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using mail merge to make place cards. One record with data over two pages	drew.last	Mail Merge	2	03-05-2015 04:37 PM
Merge From Excel With Table in Word - Next Record If Excel Column Same?	misscrf	Mail Merge	2	10-15-2014 11:51 PM
Mail merge from Excel to Word and include hyperlinks	chay	Mail Merge	5	09-28-2013 01:16 AM
Email Merge to include CCs, with 1 attachment instead of many	Auslegung	Mail Merge	0	06-12-2013 03:20 PM
avoid duplicete record and merge the record with the existed record	hemant.behere	Excel	0	01-10-2012 02:53 AM