#1
|
|||
|
|||
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 }}¶ HTML Code:
Atlanta Galos $3,000 Delaney $50,000 Henningsen $10,000 Houston Johnson $8,000 Kelly $9,000 Pak $0 Yhanks ! Ely |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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 ! |
#4
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#5
|
|||
|
|||
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 ? |
#6
|
||||
|
||||
I think you don't try very hard. All it takes is copy/paste then change mergefield names. See attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |