mail merge access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Mail merge in access

Mail merge in access

resolvedResolved · Low Priority · Version Standard

replyReply Thu 6 Mar 2008, 14:54Delegate Kelly said...

Kelly has attended:
Access Introduction course

Mail merge in access

how do i perform mail merge in access?

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Mar 2008, 09:25Trainer Pete said...

RE: mail merge in access

Hi Kelly, thank you for the post, welcome to the forum, in answer to your question on performing a mail merge in Access, consider first the data and ensure that your table or query is going to provide the correct information, if you are comfortable and wish to use the table/query proceed as follows.
In Microsoft Word create your letter/document which you wish to send to multiple addressees, invoke the Mail Merge wizard, following the steps in the wizard to undertake a mail merge; when you come to the point to insert the database, navigate to your Access database and select the table/query you wish to use, insert the fields as required and Word will extract the data. I hope that helps, best regards Pete.

 

Please browse our web site to find out more about
microsoft access training class and other Microsoft training courses.

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard