Help with Mail Merge please ?

[June7]

Sorry, I give up on your db.

I downloaded sample db from http://www.access-programmers.co.uk/...d.php?t=211933 see post #9 - in spite of what post says, the db is an mdb.


This example uses 3 files:
Access database
Word document
a text file of field names

It works. Follow instructions in the db to change file path in the code. Maybe you can adapt the working example to your db.

[bellevue]

Thanks June7

I've had a look at this and it seems ideal; however, I'm struggling to work out how to change the code to read the data source which is a query ("MasterDataSource")...can you help please ?

[June7]

So if you don't want to use a form's RecordSource as data source, call the MergeAllWord function with:

MergeAllWord ("SELECT * FROM MasterDataSource")

[bellevue]

Thanks ever so June7

Sorry to be thick but where would I put that code, would it replace something else and would I need to take some code out ?

Thanks

[June7]

Open the VBA editor. In the Form_Contacts module go to Sub cmdMergeAll_Click. That procedure calls a function called GoMergeAll. That function calls the MergeAllWord function. Change the GoMergeAll function code as shown in my previous post.

Or can just put call to MergeAllWord directly in the Click event in place of GoMergeAll.

[bellevue]

Hello June7

Thanks for that; I should be able to work that out.

However, I've found a better option, still from Albert Kallal, and this version, the Super Easy Word Merge (http://www.kallal.ca/msaccess/msaccess.html - it's about half way down the page) doesn't open up another database to perform the merge.

On top of that, you can place one command button on a form and when you click it, it opens a menu of templates to use which is much better for me as I'll eventually have quite a few templates to use.

The problems I have is how to amend what code to ensure it works with a query as the data source and also how to get it work on my form, which I think is a subform, (you open the form "Reservations" by pressing a command button on "Customers").

Sorry to be asking again but do you know what I need to do please ?

Thanks

[June7]

I can't work with db files until after Feb 22. If you still need help then, let me know with another post.