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 » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mail merge nesting if then statements

Thread Tools Display Modes
Old December 12th 12, 11:18 PM
Cameron6686 Cameron6686 is offline
Junior Member
First recorded activity by WordBanter: Dec 2012
Posts: 1
Default Mail merge nesting if then statements

I am making a service order sheet with all the contact info being pulled from outlook.

I have prices for external cleaning and internal cleaning on the same price that i want to be put into the form

{ mergefield Initial_outside } / { mergefield Initail_IO } easy enough

however If there is no data in those fields I want it to be ____________ blank so I can have a line to write on if needed. that would be easy too except if one field has something then it messes up the format and shifts everything over.

here is what i am trying to do

if data1 is blank and if data 2 is blank then display "________" if data 1 is blank and data 2 has info then display___/"data2" but if data 1 has data then display data 1 and if data 2 has data then display data

hope that makes sense

I am using word 2010 and outlook 2010

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
IF Statements in Mail Merge Lurkette Mailmerge 2 February 16th 10 08:38 PM
If/ and/ or statements with mail merge. ibmm Mailmerge 1 January 12th 10 11:48 PM
Mail merge question If Statements JAnderson Microsoft Word Help 4 January 29th 08 04:52 PM
Mail Merge if... then statements aaron Mailmerge 1 October 13th 06 06:08 PM
How can I write IF statements in Mail Merge Sayali Mailmerge 3 March 4th 05 08:31 AM

All times are GMT +1. The time now is 01:08 PM.

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