View Single Post
  #26  
Old February 14th, 2008, 07:18 PM posted to microsoft.public.word.mailmerge.fields
gjupp via OfficeKB.com
external usenet poster
 
Posts: 10
Default Using dates during mail merge

Many thanks again for your further input. It is much appreciated. Please also
see my final post to Graham Mayor.

Peter Jamieson wrote:
Where Graham has "date2" you need to put the name of the field in the data
source that you want to compare with (i.e. that has the date in "1st
February 2008" format)

(i.e. Graham's example has used the name "date2" where my example has used
"mydatetext", but in both cases you need to substitute the name in your data
source.)

Other than that, AFAICS, Graham's fields should work - if you change the two
{ DATE } fields in my example so that instead of looking like

{ DATE .... }

they look like

{ REF MyDate .... }

you should be there. In theory there's a typo (unusual for him :-) ) in
Graham's code:

{ ASK MyDate "Start Date" \d { Date \@ "dd/MM/yyyy} \o }

should have an extra quote:

{ ASK MyDate "Start Date" \d { Date \@ "dd/MM/yyyy" } \o }

but in practice it works as it is.

I'd select your field codes and press F9 to re-execute them after you change
them.

Many thanks for this. I tried it out but couldn't make it work. I even
tried

[quoted text clipped - 44 lines]
--
Message posted via http://www.officekb.com


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200802/1