Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dates in Mail Merge 1

Status
Not open for further replies.

Largefry

Programmer
Apr 28, 2003
9
GB
Hi,

Just wondering if i can format a date within mail merge but, should the field be null then dont display anything for that field. currently i am getting 30/12/1899 00:00:00 for a null date.

Many thanks.
 
Hi fry,
if you are using Word, try inserting Word Fields with the "If..then... else" condition

Good luck

André
 
Hi Largefry,

To set up the field coding to do this:
1. Make a duplicate of your mailmerge date field, so that you get two fields looking like:
«MergeDate»«MergeDate»
2. Select both of these fields and press Ctrl-F9, to create a set of field braces around the two fields:
{«MergeDate»«MergeDate»}
3. Type inside the nested fields so that they look like:
{IF«MergeDate»= 0 "" «MergeDate»}
4. Press F9 to update
5. Run your mailmerge.

Cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top