Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2014, 01:10 PM
jay_son jay_son is offline Mail Merge - Age field Windows 8 Mail Merge - Age field Office 2010 64bit
Novice
Mail Merge - Age field
 
Join Date: Jun 2014
Posts: 2
jay_son is on a distinguished road
Post 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.
Reply With Quote
  #2  
Old 06-30-2014, 02:33 PM
jay_son jay_son is offline Mail Merge - Age field Windows 8 Mail Merge - Age field Office 2010 64bit
Novice
Mail Merge - Age field
 
Join Date: Jun 2014
Posts: 2
jay_son is on a distinguished road
Default

Solved it myself. Created the database in excel and used: =DATEDIF(B2,TODAY(),"Y")&"bl "&DATEDIF(B2,TODAY(),"YM")&
Reply With Quote
Reply



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
Mail Merge - Age field How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Mail Merge - Age field How big can a mail merge field be? Engineer Mail Merge 2 12-11-2012 01:20 AM
Mail Merge - Age field Making the IF field work (not Mail Merge) Caroline Mail Merge 5 04-11-2011 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft