How to merge in Access

[vonniago]

I would like to use the Access information to create a mailing list, and a letter. Can this be done?

 

[LittleSmudge]

Absolutely - Yes

I assume that you have a table containing the data you need - something along the lines of

tblMailList
FirstName
Surname
Address1
Address2
Address3
Town
County
Postcode
etc.. ..
etc..


So all you need to do is create a Report
In the report place the controls for name address etc in the appropriate places
Create other textbox controls to contain the 'boiler plate' content of the mail merge letter.

Run the Report.

For the Labels, create another new report using the Labels wizard.


QED.

G LS


PS
If you need field contents within the boiler plate you can make the Control Source of the text box something like:-

="I understand you live in " & [Town] & ". So I will come to visit you when I an mext in " & [County] & "."

etc.