Reply
 
Thread Tools Display Modes
  #1   Report Post  
[email protected] VG44@PTF is offline
Junior Member
 
Posts: 0
Default SYNTAX ERROR in Mail Merge

I am trying to write some logic for a mail merge that sums 2 fields in Word but there is a chance that either of the fields could be blank. When it is blank, I get a Syntax Error. I have googled and written different ways and cannot get it to work. Any ideas what I am doing wrong?

{ = if { MERGEFIELD PNT_500 } = "" 0 { MERGEFIELD PNT_500 } + if { MERGEFIELD PNT_100 } = "" 0 {MERGEFIELD PNT_100 }}
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 Math - Syntax Error MerissaGargiulo Mailmerge 0 September 7th 12 07:08 PM
Formula Syntax Error in Footer kfrancis Page Layout 4 December 6th 06 05:00 PM
IF statement problem !Syntax Error, ! jlawson Microsoft Word Help 7 July 12th 06 03:42 PM
Formula - Syntax Error ArchieDog via OfficeKB.com Tables 2 June 8th 06 06:59 AM
If Formula syntax error BigPig Tables 5 February 3rd 06 05:52 PM


All times are GMT +1. The time now is 06:22 AM.

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

About Us

"It's about Microsoft Word"