If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mailmerge from Access Query - Data missing in Word
Hi
I am using Office 2007. I have a simple database which contains about 20 records. Have created a query to find people who live in a certain area. This query is then required to be merged to a Word document. I have tried doing this straight from access and I have also tried from Word using the mailmerge wizard. Which ever method I use I when I tell it to use the query the data in the query is missing when in Word. I found another message in this forum which is similar and suggests using a make "table query" will get over the problem, however, this is for an exam for students and they must use the query for the mailmerge. I have also tried using the word advanced options "Confirm File Format on Open", this does work but is very confusing for the students. A colleague has also tried to use to do the same in Office 2003 and it does not work in that either Hope someone can come up with a simple explanation. Thanks Shirley Last edited by shirl : February 12th, 2009 at 09:25 PM. Reason: added comments re-2003 |
#2
|
|||
|
|||
Mailmerge from Access Query - Data missing in Word
Yes, it can be confusing.
Is your query a "parameter query" (where the user has to provide the value of one or more fields), or does it contain wildcards (LIKE 'something*'), user-defined functions (written in Access VBA), financial series functions, or the "replace" function? If so, let us know which - perhaps a simpler query would demonstrate the specific thing you want to demonstrate (not sure what that is exactly) without so many problems. Peter Jamieson http://tips.pjmsn.me.uk shirl wrote: Hi I am using Office 2007. I have a simple database which contains about 20 records. Have created a query to find people who live in a certain area. This query is then required to be merged to a Word document. I have tried doing this straight from access and I have also tried from Word using the mailmerge wizard. Which ever method I use I when I tell it to use the query the data in the query is missing when in Word. I found another message in this forum which is similar and suggests using a make "table query" will get over the problem, however, this is for an exam for students and they must use the query for the mailmerge. I have also tried using the word advanced options "Confirm File Format on Open", this does work but is very confusing for the students. Hope someone can come up with a simple explanation. Thanks Shirley |
#3
|
|||
|
|||
Hi
It is just a simple Access query with the critera Like A* to find all the postcodes which begin with A. Shirley Quote:
|
#4
|
|||
|
|||
Mailmerge from Access Query - Data missing in Word
OK, there is unfortunately a problem with using wildcards in queries
being used by merge, because Access itself expects to use * for multiple characters and ? for single charactes, but when Word 2002 or later gets data from Access, it uses OLE DB which does not recognise * and ? but wants to use % and _ instead. The simplest thing to do in this case is probably to have two queries, one with Like 'A*' for use within Access itself, and another with Like 'A%' for use by merge. Obviously, if you only have to present one of these to students, life will probably be simpler... Peter Jamieson http://tips.pjmsn.me.uk shirl wrote: Hi It is just a simple Access query with the critera Like A* to find all the postcodes which begin with A. Shirley Peter Jamieson;3202208 Wrote: Yes, it can be confusing. Is your query a "parameter query" (where the user has to provide the value of one or more fields), or does it contain wildcards (LIKE 'something*'), user-defined functions (written in Access VBA), financial series functions, or the "replace" function? If so, let us know which - perhaps a simpler query would demonstrate the specific thing you want to demonstrate (not sure what that is exactly) without so many problems. Peter Jamieson http://tips.pjmsn.me.uk shirl wrote:- Hi I am using Office 2007. I have a simple database which contains about 20 records. Have created a query to find people who live in a certain area. This query is then required to be merged to a Word document. I have tried doing this straight from access and I have also tried from Word using the mailmerge wizard. Which ever method I use I when I tell it to use the query the data in the query is missing when in Word. I found another message in this forum which is similar and suggests using a make "table query" will get over the problem, however, this is for an exam for students and they must use the query for the mailmerge. I have also tried using the word advanced options "Confirm File Format on Open", this does work but is very confusing for the students. Hope someone can come up with a simple explanation. Thanks Shirley - |
#5
|
|||
|
|||
Peter
Thanks for the reply, a colleague has also found a similar response and we will report it to the exam board, I suspect that whoever wrote the exam paper did not test using a query for a mail merge. Thanks for taking the time to reply Shirl Quote:
|
Thread Tools | |
Display Modes | |
|
|