Mail Merge

[muppet123]

Hi

Is there a way of carrying out a mail merge function within Access? I have a DB with 4 tables 'stage1 thru to 4'
Stage 1 is the contact details including address etc, stage 2,3 are questions and stage 4 is an appointment setting stage.

Is there a way to create a mail merge using the data is stage 1 and incorperate 2/3/4 in the process so that a letter be sent out?

Many thanks
Mup'

 

[KenReay]

Yes

You can either make teh query within Access, and then use Word to retrieve that query and do a mail merge,

or

You can do it all from within Access by creating an instance of word and controling it from Access

Not sure which bits you do not know how to do, see Create Object and GetObject in help to get you started with the second method

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[muppet123]

Thanks Ken I will experiment