Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pama pama is offline
external usenet poster
 
Posts: 3
Default mail merging date fields from excel

Hello everyone,
I have the same problem as the post on 12/8/05 "Data fields in mail merge",
so I will use their elequent words...
"I have a Word mail merge document, used to import Excel data - only dates.
When I have merged the data, all empty Excel date cells are populated in Word
by 12:00AM."
I then tried the fix for it.....
Use

{ IF { MERGEFIELD contract_received } "" { MERGEFIELD contract_received
\@"DD/MM/YYYY" } "" }

But this did not work.
Any suggestions?

 
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
Skip mail merge fields from Excel Workbook when blank/zero akumudzi New Users 1 July 16th 06 03:44 PM
Skip mail merge fields from Excel when blank/zero [email protected] Mailmerge 1 July 16th 06 03:43 PM
Keep formating when mail merging from excel to word address labe timfitz Mailmerge 2 July 6th 06 07:54 AM
How do I stop losing formtext fields when mail merging a document Angus Maule UK Mailmerge 1 April 25th 06 11:39 AM
How can I maintain Excel date formats in a mail merge? MKLeisure Mailmerge 1 August 30th 05 08:09 PM


All times are GMT +1. The time now is 08:02 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"