Search the Community
Showing results for tags 'access'.
I have always had trouble getting mail-merge (MM) letters created on my desktop at home to work when copied to another computer. It just happened again. The scenario goes like this: * Write query in MS Access (2000). * Create the form letter. * Use the MM toolbar to select the data source. * Insert fields When I run the MM letters, they work perfectly. I then take the letters to a client where the path to both the query and the letters is identical to what it is on my computer. However, the version of Office is 2003, not 2000. I get error messages that it can't find the DDE something or other, and a dialog box pops up with a button to "Find data source". I click it and it lists all the tables and queries from the correct database. Pick the query. Window opens ask me to pick the fields I want to use. Trouble is, none of the fields from the query are there. I'm not even sure where they're coming from. At one point, it asked if I wanted to remove the header information, which I did, then started all over again. Same result. I almost seems like you have to create the MM letters on the computer on which they're going to be used, else it doesn't work. What am I doing wrong?