#1
|
|||
|
|||
Mail Merge - Age field
I'm a complete novice but slowly getting there with mail merge.
I'm trying to use mail merge with microsoft word. I've created a letter and successfully added a name field, date of birth field, today's date field. Those fields are showing the correct information on my letter now. The field I really want now is an age in years and months field. E.g. Date of birth: 21/08/2000 Age: 13.10 The age would show something similar to above, the age in years followed by the number of full months. It it possible for something like this or something similar? Last edited by jay_son; 06-30-2014 at 02:33 PM. |
#2
|
|||
|
|||
Solved it myself. Created the database in excel and used: =DATEDIF(B2,TODAY(),"Y")&"bl "&DATEDIF(B2,TODAY(),"YM")&
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
Mail Merge Empty Data Field | Licos101 | Mail Merge | 2 | 04-10-2014 06:19 AM |
How to ignore a mail merge field if the field is blank | redzan | Mail Merge | 1 | 05-16-2013 08:34 AM |
How big can a mail merge field be? | Engineer | Mail Merge | 2 | 12-11-2012 01:20 AM |
Making the IF field work (not Mail Merge) | Caroline | Mail Merge | 5 | 04-11-2011 04:17 PM |