A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Conditional Mail Merge



 
 
Thread Tools Display Modes
  #1  
Old September 24th 08, 10:46 PM posted to microsoft.public.word.docmanagement
pls
external usenet poster
 
Posts: 1
Default 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!


Ads
  #2  
Old September 25th 08, 01:53 AM posted to microsoft.public.word.docmanagement
$hri...![_2_]
external usenet poster
 
Posts: 25
Default 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  
Old September 25th 08, 05:57 AM posted to microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
 
Posts: 19,312
Default 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!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional mail merge from Contacts Terry Lemons Mailmerge 2 January 2nd 08 01:28 AM
Mail Merge, Conditional INCLUDEPICTURE Jan Kronsell New Users 7 March 17th 06 11:32 AM
Conditional Mail Merge Help Susan Ramlet Mailmerge 0 August 22nd 05 06:26 PM
How do I do a conditional mail merge into a table tomtraff Mailmerge 5 March 29th 05 05:29 PM
Conditional mail merge Hanif Mailmerge 1 November 26th 04 07:10 PM


All times are GMT +1. The time now is 02:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.