Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 08-10-2016, 11:03 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 Possible to use Mail Merge for a One to Many?

Thanks for your politeness Graham, in responding to my questions. Please remember though, that while something may be crystal clear to you and other "gurus on here, most of us are not on your level of expertise and understanding of Microsoft Office products.

I have tried to follow several Microsoft articles on "how to use mail merge to create a list sorted by category in Word (article 211303)." I think now category = directory? I have tried the sample code, but ALL THE ARTICLES, at least the ones I've seen, make no mention what steps to do after you finish typing in the Field Code.

Please correct me if I'm wrong. Excel workbook with data is closed and you are in a blank Word document. The steps I am now following are:
Mailings > Start Mail Merge > Directory > Select Recipients > Find Excel workbook, double left click, and click worksheet the data is on > OK using Ctrl+F9 insert braces and code in between the braces. After code is entered, then what?

If possible, I would like to have a separate Word Document for each company with multiple lines of information for that company, say names of chemicals. Understand the concept of using IF's but cannot get code to work. My key field would be a company identification number. If I can just find a good example of code, that tells me what to do after the code is typed in, I think(?) I can accomplish.

Then, possibly VBA(?) attached each document to an email generated from Email merge.

If I do accomplish, I would be most happy to share with other. I can do "normal" email merge now pretty efficiently. Did learn though, make doubly sure Track changes are off, as well as mark-ups, or they'll transfer over to your email message!
Major Egg on Face!!

Thanks in Advance,
Mort in Dallas
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 07:40 AM.


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