Microsoft Office Forums How to combine several records in a single letter in Word 2010

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2015, 07:29 PM
May May is offline How to combine several records in a single letter in Word 2010 Windows 7 32bit How to combine several records in a single letter in Word 2010 Office 2010 32bit
Novice
How to combine several records in a single letter in Word 2010
 
Join Date: Mar 2015
Posts: 2
May is on a distinguished road
Default How to combine several records in a single letter in Word 2010


I am using MS Word 2010. I follow the instructions in http://support.microsoft.com/en-us/kb/211303/en-us, unfortunately, I can't make it work. Attached please find the data file. Please help.
Attached Files
File Type: xls testdata.xls (22.5 KB, 2 views)
File Type: docx mailmerge.docx (15.6 KB, 2 views)
Reply With Quote
  #2  
Old 03-25-2015, 12:09 AM
gmayor's Avatar
gmayor gmayor is online now How to combine several records in a single letter in Word 2010 Windows 7 64bit How to combine several records in a single letter in Word 2010 Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,809
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

You have fields within fields e.g. { MERGEFIELD { MERGEFIELD City }} whereas it should simply be { MERGEFIELD City }. But you may find the process easier to follow if you look at Paul Edstein's tutorial which you can download from the downloads page of my web site.

And if you want separate documents for each city, you should find http://www.gmayor.com/ManyToOne.htm altogether simpler to set up, though this is not a true mail merge process.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-25-2015, 01:44 AM
May May is offline How to combine several records in a single letter in Word 2010 Windows 7 32bit How to combine several records in a single letter in Word 2010 Office 2010 32bit
Novice
How to combine several records in a single letter in Word 2010
 
Join Date: Mar 2015
Posts: 2
May is on a distinguished road
Default

Dear Graham

Thanks for your kind help. I am now able to produce a single document with page breaks separating at the "Key" changes. However, if I change the document type to e-mail messages, the grouping doesn't work. Instead, it geneate each records in excel as a separated email like this

email 1
123456 Vicky 100.00

email 2
A98765 May 50

email 3
A98765 May 500

But, I would like to send the email to recepients like below
email 1
123456 Vicky 100.00

email 2
A98765 May 50
A98765 May 500


Please help
Reply With Quote
  #4  
Old 03-25-2015, 03:36 AM
gmayor's Avatar
gmayor gmayor is online now How to combine several records in a single letter in Word 2010 Windows 7 64bit How to combine several records in a single letter in Word 2010 Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,809
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

If you are using the original process, you will have to merge to a new document then split it and mail the resulting documents.

http://www.gmayor.com/ManyToOne.htm will do it all in one process, but you will have to create a new merge document to work with it. See the example file which is more or less what you are doing.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to combine several records in a single letter in Word 2010 Word 2010 - Letter name/address auto populate Nicksaerian Word 1 08-08-2014 10:57 AM
single task with combine SS and FF dependencies Blobb Project 3 06-04-2014 12:24 PM
How to combine several records in a single letter in Word 2010 formulae to combine excel records H28Sailor Excel 7 03-31-2013 02:26 PM
combine multiple documents word starter 2010 bribelge Word 3 12-19-2012 09:25 AM
How to combine several records in a single letter in Word 2010 Combine Records when Mail Merge from Access Tom Pickles Misc 2 08-24-2010 06:00 PM


All times are GMT -7. The time now is 11:52 PM.


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