Date Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kushum - 30 Aug 2005 14:05 GMT

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 to this Message

Doug Robbins - 30 Aug 2005 20:49 GMT

Use an If...Then...Else field that checks if DOB is blank

{ IF { MERGEFIELD DOB } = "" "" "{MERGEFIELD DOB \@ "dd/MM/yy"} }

Signature

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

> Hi,
> I have entered the following for my field "DOB" which is sourced from
[quoted text clipped - 6 lines]
> I would appreciate every help I get.
> Thankyou in advance.

Reply to this Message

Kushum - 31 Aug 2005 12:12 GMT

How do i actually implement this code?

> Use an If...Then...Else field that checks if DOB is blank
>
[quoted text clipped - 10 lines]
> > I would appreciate every help I get.
> > Thankyou in advance.

Reply to this Message

Doug Robbins - 31 Aug 2005 19:41 GMT

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.

Signature

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

> How do i actually implement this code?
>
[quoted text clipped - 12 lines]
>> > I would appreciate every help I get.
>> > Thankyou in advance.

Reply to this Message

Rate this thread: