Posted: Fri Dec 21, 2007 2:05 pm Post subject: Time format problem
MERGEFIELDHi, I use a MS Word 2003 and Access 2003 on a Windows XP machine. I
fill data into the Access DB and then open a word doc mail merged to the DB.
I had it working fine for 2007 but I just created the 2008 version by copying
the two files and changing the data set.
All the data is populated into the word doc perfectly except for the time.
It shows the time as 1899-12-30 19:00:00 instead of 19:00.
I am using the mergefield code {MERGEFIELD "End Time"\@"h:mm"} and I've
tried various other variations but it still shows the same.
Is there a work around for this problem? I seem to remember some sort of
patch was required a while back for something like this.
Any help greatly appreciated.
Posted: Fri Dec 21, 2007 2:16 pm Post subject: Re: Time format problem
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
MERGEFIELDHi, I use a MS Word 2003 and Access 2003 on a Windows XP
machine. I fill data into the Access DB and then open a word doc mail
merged to the DB. I had it working fine for 2007 but I just created
the 2008 version by copying the two files and changing the data set.
All the data is populated into the word doc perfectly except for the
time. It shows the time as 1899-12-30 19:00:00 instead of 19:00.
I am using the mergefield code {MERGEFIELD "End Time"\@"h:mm"} and
I've tried various other variations but it still shows the same.
Is there a work around for this problem? I seem to remember some sort
of patch was required a while back for something like this.
Any help greatly appreciated.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
