Recent content by dmacleod

Thanks Just what I was looking for. The only issue I have so far is when I click on this button I get the following Compile error "Sub or function not defined" with the "ShellExecute" highlighted.

Thanks. I am fully aware of what a mail merge is and how to do it when I am in word. I am just looking for some small tips to help me automate if from my database.

Macro to open word doc Can someone help me with a macro? I have only been working on access databases for a couple of weeks now but learning fast. I would like to use a macro to open a word doc. I can open the doc with the following code( Application.FollowHyperlink "C:\Template.doc") . I need...

Can you explain? Like I said. I am new to creating databases

Thanks Set warnings works well. How do I follow the hyperlink in a macro? Do i have to do this differently? I just want to have the one button to apply the filter and then launch word with the particular document

Thanks, Seems to put me on the right path. I now have 2 issues. 1. The button that I use to launch the mail merge has to do 2 things, (a) reun the query, and (b) launch the word file. I am currently launching it by the following {Application.FollowHyperlink "C:\Template.doc"}. 2. When I run the...

Hi All, I am new to creating access databases but I am learning quickly. I am trying to create a mail merge in a database that I am working on but having a small issue. If I create a query to merge 2 tables together I can mail merge ok, but I have all records in the table as recipients. If I set...