Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
David Hall
 
Posts: n/a
Default Showing todays date when the Excel value is zero

Hi, this problem is really frustrating me so if you can help I would really
appreciate it.

I am using Word 2003 and Excel 2003 to do a mailmerge and I am having a
problem with todays date being inserted in the Word document when the Excel
value is zero. I would either like to show the date that is entered in the
Excel sheet or nothing if the Excel value is zero.

My entry in the Word document is:
{IF{MERGEFIELD E_Start} = 0 "" {MERGEFIELD E_Start \@ "d MMMM yyyy}

Where am I going wrong?

Many thanks
David Hall


 
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
The Web Archive Converter puts todays date on MHT copies of old f zzz Microsoft Word Help 1 December 12th 05 12:56 PM
Mail Merge of a Date from Excel Data into Microsoft Word Keith A Microsoft Word Help 2 August 31st 05 05:01 AM
Excel date format merging to Word XP version Linda - Xtremly Peeved Mailmerge 11 April 12th 05 06:50 AM
How to prevent Merged Date Field showing time? jmasood Mailmerge 1 February 21st 05 11:59 AM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 07:34 AM


All times are GMT +1. The time now is 12:09 AM.

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"