View Single Post
 
Old 07-13-2014, 07:04 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached. Simply save both files to the same folder. Note the extra column in the worksheet to calculate the expiry dates.

Of course, you may not want the shading I've used for the tables. The output format, including the shading, is controlled by field switches. To see the field codes and switches, press Alt-F9. For an overview of what they do and how they're used, see: http://office.microsoft.com/en-us/wo...010260104.aspx. That link refers to a 'Table AutoFormat dialog box', which you can access via Insert|Quick Parts|Field>DataBase.
Attached Files
File Type: zip CertificationExpiry.zip (30.4 KB, 206 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote