Reply
 
Thread Tools Display Modes
  #1   Report Post  
Candice
 
Posts: n/a
Default setting a condition in mail merge

How do I set a condition so that when I do the mail merge....if one
mergefield is blank from my data source I want it to fill in with an
atlernate mergefield? Example: my spreadsheet has FirstName, LastName,
Company...If the FirstName is blank then fill in with Company Name?

Please Help!!!
--
Candice
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

{IF {Mergefield FirstName} "" "{Mergefield FirstName}" "{Mergefield
Company}"}

Insert all the curly field brackets with CTRL+F9 and type the rest.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Candice wrote:
How do I set a condition so that when I do the mail merge....if one
mergefield is blank from my data source I want it to fill in with an
alternate mergefield? Example: my spreadsheet has FirstName,
LastName, Company...If the FirstName is blank then fill in with
Company Name?

Please Help!!!



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
mail merge if ... then else condition Rong Mailmerge 7 April 28th 05 03:07 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM


All times are GMT +1. The time now is 05:51 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"