Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-05-2016, 10:04 AM
Sgt Rock Sgt Rock is offline Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each  Record Emailed? Windows 8 Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each  Record Emailed? Office 2010 64bit
Novice
Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each  Record Emailed?
 
Join Date: Nov 2013
Location: Dallas, Texas
Posts: 16
Sgt Rock is on a distinguished road
Default Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each Record Emailed?

Up front - thank you to those more proficient than I in this subject matter.



I have spent the last several days researching this. I have browsed most of the pertinent questions asked within the Mail Merge Forum. Because of apparent differences between Email and Mail Merge, it may be of benefit to have two forums. Maybe there is and I missed it for I've have not used this site much, but am at wits end to solve the following dilemma.

First, yes, I've read many of Mayors stuff along with Macropod's, in addition to a gazillion other references and sites

Second: This has to do with emailing, and not land locked mailings of hard copied documents. However, after reading below, it may be that a hard document be generated in Word, and attached to an email going to the intended recipient. If than can in fact be done.

The Issue: Each record, that is to be emailed to a recipient, contains information that is found on multiple rows in Excel. Example: A facility may have 2-3-4-X number of chemicals I am interested in, along with other information associated with each of those chemicals. So, it is not feasible to combine all the chemicals into a single cell separated by commas.

Is it possible to do this using Directory and emailing? According to one document I read by Macropod, this cannot be done. This may be the reason that if one uses Directory, then there is no way of telling Word, that I've seen, the document is to be emailed and not mailed.

If in fact it is not possible to email merge multiple lines of information into a single record, then might someone direct me to step by step instructions for inserting "field codes" in Word and basing the If test on a facility identification number. If the facility identification number is the same for say, all 3 chemicals, include all 3 of those in a single document. When the facility identification number changes, then go to a new document.

Am especially interested in sites that explain & instruct about Field Codes and how to use them.

If I must attach a Word document to my email, the instructions how to do so would also be most, most beneficial, and to save what lil hair I have left on my head - smile.

Thanks in advance for those in sharing their knowledge.
Mort
Reply With Quote
 



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
Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each  Record Emailed? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft