Mail merge question using Access.

[kjspear]

Hello everyone:

I have a question about doing a mail merge in Word XP from an Access Table. Basically I'm trying to automate this merge so that all the user has to do is select their choices from drop down boxes in Word. I have a registration table in Access. What I would like to do is allow the user to simply query the information such as Name of Event, Date of Event, etc. I know how to do this manually. But I would like it to be done automatically upon selection from the user. This is basically a Thanks for Attending letter. The reason for the drop down boxes is because there are several events thoughout the year and I'm trying to set this up with the least amount of administrative hours setting is up for each event.

Is there a way to do this so that the users do not have to wait for me to manually set up the mail merge for every event?

Thank you,
KJ

 

[MoiraT]

Will your users be running the mail merge from Access or from Word? If from Access then you could create a query with a parameter prompt for them to select the criteria they want then Tools, OfficeLinks, Merge it with MS Word.
If they are started within Word then you can use the Mail Merge Wizard, create a link to the Access table as the data source and save that link for later use. When the data is displayed in Word you can select based on criteria.
Hope that helps