dateofbirth to age in mailmerge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Nav - 03 Feb 2005 23:19 GMT

I have a mailmerge field containing date of birth .
I want to display the correct age in years.
I have numerous vba functions I can use to calculate the age, but how do I
go about applying a function to a mailmerge field?

Reply to this Message

Greg Maxey - 03 Feb 2005 23:27 GMT

Andrew,

See:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> I have a mailmerge field containing date of birth .
> I want to display the correct age in years.
> I have numerous vba functions I can use to calculate the age, but how
> do I go about applying a function to a mailmerge field?

Reply to this Message

Doug Robbins - 03 Feb 2005 23:28 GMT

I would suggest that you do the calculation in the datasource.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have a mailmerge field containing date of birth .
> I want to display the correct age in years.
> I have numerous vba functions I can use to calculate the age, but how do I
> go about applying a function to a mailmerge field?

Reply to this Message