Hello,
I am sure this has been addressed before but my simple search did not find a result.
Is there a macro to display someone's age based on their DOB from a merge?
Thanks!
Christian
So you have someone's date of birth in a column and you want their age to use in a mail merge? You can use a formula like this to calculate their age in a spare column: =DATEDIF(A1,TODAY(),"Y")
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you Dom, This should work.Originally Posted by Domski
Does it work if I am pulling dates from a merge instead of a column? I am happy to replace A1 with a merge field, but I don't know if it will populate correctly. Just checking.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks