A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mailmerge from Access Query - Data missing in Word



 
 
Thread Tools Display Modes
  #1  
Old February 12th, 2009, 04:12 PM
shirl shirl is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
Question 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 10:25 PM. Reason: added comments re-2003
  #2  
Old February 13th, 2009, 12:05 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default 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  
Old February 13th, 2009, 01:42 PM
shirl shirl is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
Default

Hi

It is just a simple Access query with the critera Like A* to find all the postcodes which begin with A.

Shirley

Quote:
Originally Posted by Peter Jamieson View Post
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



  #4  
Old February 13th, 2009, 06:07 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default 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  
Old February 13th, 2009, 10:25 PM
shirl shirl is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
Thumbs up

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:
Originally Posted by Peter Jamieson View Post
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



-




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.