Query for mail merge.

[kacey8]

Hi,

So I have the following query which works perfectly (and will be use to create a report) but when the query runs to create the report I also want it to mail merge some of the items into word to be used on address labels.

SELECT Dunmow.Date, Dunmow.Undeliverable, Dunmow.Duplicate, Dunmow.[OTM with XXXXXX], Dunmow.[Landlords Salutation], Dunmow.[LL Address 1], Dunmow.[LL Address 2], Dunmow.[LL Address 3], Dunmow.[LL Address 4], Dunmow.[LL Address 5], Dunmow.[LL Postcode], Dunmow.[Letter 1], Dunmow.[Letter 2], Dunmow.[Letter 3], Dunmow.[Letter 4], Dunmow.[Letter 5], Dunmow.[Letter 6], Dunmow.[Letter 7], Dunmow.[Letter 8]
FROM Dunmow
WHERE (((Dunmow.Date)=DateAdd("d",-7,Date())) AND ((Dunmow.Undeliverable)=False) AND ((Dunmow.Duplicate)=False) AND ((Dunmow.[OTM with XXXXXX])=False) AND ((Dunmow.[Letter 1])=False));

So thats my query, What I want it to do is to take the following

[Landlords Salutation]
[LL Address 1]
[LL Address 2]
[LL Address 3]
[LL Address 4]
[LL Address 5]
[LL Postcode]

and use it for a merge item to create the labels required.

I have googled this but I am not having a lot of luck, I have a standard word document/label document I wish to paste this into.

 

[pr2-eugin]

Here are some links to get you started :

http://www.kallal.ca/msaccess/msaccess.html (search for Super Easy Word Merge)
http://www.rogersaccesslibrary.com/forum/topic396.html
http://www.blueclaw-db.com/mail-merge-bookmarks.htm

 

[kacey8]

Okay... I think I probably bit of WAY more than I can chew here, it's all blowing over my head.

 

[pr2-eugin]

Albert Kallal's Super Easy Merge is probably the best for you. Have a read through of what it does, you do not have to worry about messy coding, it is all done for you. You only have to Copy the Forms and Modules into your application. As simple as that.

Good Luck !