Microsoft Office Forums How to use mail merge to create a list sorted by category in Word

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2014, 03:21 PM
elisa2013 elisa2013 is offline How to use mail merge to create a list sorted by category in Word Windows 8 How to use mail merge to create a list sorted by category in Word Office 2010 64bit
Novice
How to use mail merge to create a list sorted by category in Word
 
Join Date: Mar 2014
Posts: 3
elisa2013 is on a distinguished road
Default How to use mail merge to create a list sorted by category in Word

Hi to everyone !
I'm crazying with mail merge , does not work as in the example :

http://support.microsoft.com/kb/294686/en-us

this script doesn't work:
HTML Code:
 { IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }
" "" }{ SET Place1 { MERGEFIELD CITY }}
{ If { Place2 } <> { Place1 }"
{ MERGEFIELD CITY }

{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }} 
  
I would like:

HTML Code:
  
 Atlanta

Galos $3,000
Delaney $50,000
Henningsen $10,000

Houston

Johnson $8,000
Kelly $9,000
Pak $0 
Please, Can you help me?
Yhanks !


Ely
Reply With Quote
  #2  
Old 03-13-2014, 09:17 PM
macropod's Avatar
macropod macropod is offline How to use mail merge to create a list sorted by category in Word Windows 7 32bit How to use mail merge to create a list sorted by category in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,536
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

For a better and far more comprehensive implementation, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327
http://windowssecrets.com/forums/sho...l=1#post928391
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-14-2014, 12:07 AM
elisa2013 elisa2013 is offline How to use mail merge to create a list sorted by category in Word Windows 8 How to use mail merge to create a list sorted by category in Word Office 2010 64bit
Novice
How to use mail merge to create a list sorted by category in Word
 
Join Date: Mar 2014
Posts: 3
elisa2013 is on a distinguished road
Default

Thank's MacroPod!
i'm writing your guide, it's wery well but
I'm sorry, can you help me on my example?
Thank you very much !
Attached Files
File Type: zip prova.zip (20.0 KB, 39 views)
Reply With Quote
  #4  
Old 03-14-2014, 12:22 AM
macropod's Avatar
macropod macropod is offline How to use mail merge to create a list sorted by category in Word Windows 7 32bit How to use mail merge to create a list sorted by category in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,536
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Have you experimented with any of the tutorial's fields, simply copying them to the sample mailmerge main document to see how they work? The field structure in your document isn't anything like what the tutorial uses. Besides which, I don't know how you intend your output to appear.

PS: The fields from the MS website do work; they just don't do so as well as the fields I've crafted.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-14-2014, 01:34 AM
elisa2013 elisa2013 is offline How to use mail merge to create a list sorted by category in Word Windows 8 How to use mail merge to create a list sorted by category in Word Office 2010 64bit
Novice
How to use mail merge to create a list sorted by category in Word
 
Join Date: Mar 2014
Posts: 3
elisa2013 is on a distinguished road
Default

Yes, I'm trying but and your guide is very well but I can't work .
you are very good , please, could you help me in my example ?
Reply With Quote
  #6  
Old 03-14-2014, 02:35 AM
macropod's Avatar
macropod macropod is offline How to use mail merge to create a list sorted by category in Word Windows 7 32bit How to use mail merge to create a list sorted by category in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,536
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I think you don't try very hard. All it takes is copy/paste then change mergefield names. See attached.
Attached Files
File Type: docx prova.docx (16.4 KB, 94 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use mail merge to create a list sorted by category in Word Urgent Supprt Need to Create Mail Merge letter risnasmhd Mail Merge 1 09-29-2013 08:11 PM
How to create a Main category mirrored in Sub category data entry type of solution? Geza59 Excel 0 10-19-2012 05:44 AM
How to use mail merge to create a list sorted by category in Word Need advice on category sorted e-mail merge GeoB Mail Merge 3 09-08-2011 11:03 PM
Where is the category or distribution list or group as I add new e-mail address? Jamal NUMAN Outlook 0 11-21-2010 07:34 PM


All times are GMT -7. The time now is 10:50 AM.


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