Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data fields in mail merge
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 have edited the Word field codes to UK date format (they were US), and now all empty Excel date cells are populated in Word with today's date! Is there a way of telling Word to leave empty cells alone and leave them blank? Word cells are formatted with { MERGEFIELD contract_received\@"DD/MM/YYYY" } - this is exact, including spaces. Would this formatting put a date into every Word cell, even if the corresponding Excel cell is empty? Any help will be gratefully received. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data fields in mail merge
Use
{ IF { MERGEFIELD contract_received } "" { MERGEFIELD contract_received \@"DD/MM/YYYY" } "" } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Lighthouse" wrote in message ... 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 have edited the Word field codes to UK date format (they were US), and now all empty Excel date cells are populated in Word with today's date! Is there a way of telling Word to leave empty cells alone and leave them blank? Word cells are formatted with { MERGEFIELD contract_received\@"DD/MM/YYYY" } - this is exact, including spaces. Would this formatting put a date into every Word cell, even if the corresponding Excel cell is empty? Any help will be gratefully received. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Losing Data | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
How do I remove or supress blank data in fields in mail merge e.g. | Mailmerge | |||
can data fields be added to an exisiting mail merge address list | Microsoft Word Help |