Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Cameron6686 Cameron6686 is offline
Junior Member
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

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 04:10 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"