Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Conditional Mail Merge
I'm doing a mail merge with three lines of address:
Mergefield 1: Name Mergefield 2: AddrLine Mergefield 3: CityStZip If the student's address line in field 2 is "Union Mailbox XXX", I need to suppress line 3. If they have on off-campus address, then line 3 needs to print. Based on an earlier response to a different question, I put on line 3: {IF "{MERGEFIELD AddrLine\*Union}"''{MERGEFIELD CityStZip}"} This works to suppress line 3 for those whose address begins with "Union" but it's also suppressing line 3 for all others. What am I doing wrong? Thanks! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Conditional Mail Merge
1. In a new blank document, start the mail merge. To do this, use one of the
following procedures, as appropriate for the version of Word that you are running: Microsoft Word 2002 On the Tools menu, click Letters and Mailings, and then click Mail Merge Wizard. Microsoft Office Word 2003 On the Tools menu, click Letters and Mailings, and then click Mail Merge. Microsoft Office Word 2007 On the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard. 2. In the Mail Merge task pane under Select document type, click to select Directory. 3. Click Next: Starting document. 4. Under Select starting document, click to select Use the current document. 5. Click Next: Select recipients. 6. Under Use an existing list, click Browse. 7. In the Select Data Source dialog box, select the sample file you created in the Set Up the Data File section. 8. If the Confirm Data Source dialog box appears, select a data type that is appropriate for the type of file that you created in the Set up the data file section. For example, if you created the file in Microsoft Excel, select either MS Excel Worksheets via DDE (*.xls) or Excel Files via ODBC (*.xls). 9. In the Mail Merge Recipients dialog box, click OK. 10. Using the following example as a guide, insert fields to compare the key field in each row with the key field in the previous row, and to insert one string of text if they are different and another string of text if they are the same. http://support.microsoft.com/kb/294686/en-us?FR=1 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Conditional Mail Merge
What you actually need is
{If {Mergefield AddrLine} "Union*" "{Mergefield CityStZip}"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org pls wrote: I'm doing a mail merge with three lines of address: Mergefield 1: Name Mergefield 2: AddrLine Mergefield 3: CityStZip If the student's address line in field 2 is "Union Mailbox XXX", I need to suppress line 3. If they have on off-campus address, then line 3 needs to print. Based on an earlier response to a different question, I put on line 3: {IF "{MERGEFIELD AddrLine\*Union}"''{MERGEFIELD CityStZip}"} This works to suppress line 3 for those whose address begins with "Union" but it's also suppressing line 3 for all others. What am I doing wrong? Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional mail merge from Contacts | Mailmerge | |||
Mail Merge, Conditional INCLUDEPICTURE | New Users | |||
Conditional Mail Merge Help | Mailmerge | |||
How do I do a conditional mail merge into a table | Mailmerge | |||
Conditional mail merge | Mailmerge |