Access Form to Mail Merge to Word - faq181-271

[Shairal]

Just when I thought I had found the solution (faq181-271)for my form data to mail merge in a Word.doc (and in plain language I can understand!), I can’t seem to get it to work. I’m using office 2003 – I have written my query, and it returns the data as expected.

However, when I go to create my Word doc and get to the step where I choose my source data, I am unable to find the query I’ve created in the list (other queries I’ve written appear, but not this one). I have tried adding a table and including a field from the table, but the query still does not appear in my list.

Any advice would be greatly appreciated!!

 

[hermanlaksko]

Try Helen..

http://www.helenfeddema.com/

She has a ton of code just up for graps and I know for a fact that she also has the solution for you.

Try under "Access archon" or "Code samples"

Herman
Say no to macros