Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Formatting
Hi,
I have entered the following for my field "DOB" which is sourced from MSAccess: MERGEFIELD DOB \@"dd/MM/yy" but not all DOB data has been entered: So wherever there is a blank DOB in the database, it comes up as todays date in the merged document with the above command. I would appreciate every help I get. Thankyou in advance. |
#2
|
|||
|
|||
Use an If...Then...Else field that checks if DOB is blank
{ IF { MERGEFIELD DOB } = "" "" "{MERGEFIELD DOB \@ "dd/MM/yy"} } -- 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 "Kushum" wrote in message ... Hi, I have entered the following for my field "DOB" which is sourced from MSAccess: MERGEFIELD DOB \@"dd/MM/yy" but not all DOB data has been entered: So wherever there is a blank DOB in the database, it comes up as todays date in the merged document with the above command. I would appreciate every help I get. Thankyou in advance. |
#3
|
|||
|
|||
How do i actually implement this code?
"Doug Robbins" wrote: Use an If...Then...Else field that checks if DOB is blank { IF { MERGEFIELD DOB } = "" "" "{MERGEFIELD DOB \@ "dd/MM/yy"} } -- 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 "Kushum" wrote in message ... Hi, I have entered the following for my field "DOB" which is sourced from MSAccess: MERGEFIELD DOB \@"dd/MM/yy" but not all DOB data has been entered: So wherever there is a blank DOB in the database, it comes up as todays date in the merged document with the above command. I would appreciate every help I get. Thankyou in advance. |
#4
|
|||
|
|||
In the mailmerge main document, use Ctrl+F9 to insert each pair of field
delimiters { } amd type the text in the positions shown. Use Alt+F9 to toggle off the display of the field codes. -- 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 "Kushum" wrote in message ... How do i actually implement this code? "Doug Robbins" wrote: Use an If...Then...Else field that checks if DOB is blank { IF { MERGEFIELD DOB } = "" "" "{MERGEFIELD DOB \@ "dd/MM/yy"} } -- 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 "Kushum" wrote in message ... Hi, I have entered the following for my field "DOB" which is sourced from MSAccess: MERGEFIELD DOB \@"dd/MM/yy" but not all DOB data has been entered: So wherever there is a blank DOB in the database, it comes up as todays date in the merged document with the above command. I would appreciate every help I get. Thankyou in advance. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
long date formatting in access shows as short date in word | Mailmerge | |||
Specific formatting of the date | New Users | |||
Date Field Formatting | Microsoft Word Help | |||
How do I control date formatting in a Word Mail Merge? | Mailmerge | |||
Date formatting in text form field, part II | Microsoft Word Help |