mail merge issue with Word 2010 and Access 2010

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

dmarie2128

Thread Starter
Joined
Feb 1, 2013
Messages
5
I have a word document set up with fields that I want to create a mail merge from a Query. When I go through the steps to add my query as the source then click on edit recipients there are no recipients. I have tried the same steps with other queries that I have and it works. I'm not sure why the query I want to use isn't working. The query I have set up does have a lot of expressions. Here is an example IIf([fie dt] Between #8/1/2010# And #7/31/2011#,[fie dt]+1096,Null) I have tried to change the expression and it still doesn't work. Any ideas? Thanks!
 

OBP

Joined
Mar 8, 2005
Messages
19,895
dmarie2128, welcome to the Forum.
I never use Word Mail Merge, but can I suggest that you take a copy of the query, remove all the expressions and see if it works.
If it does add back the expressions one at a time to see if one of them is the "problem".
 

dmarie2128

Thread Starter
Joined
Feb 1, 2013
Messages
5
dmarie2128, welcome to the Forum.
I never use Word Mail Merge, but can I suggest that you take a copy of the query, remove all the expressions and see if it works.
If it does add back the expressions one at a time to see if one of them is the "problem".

Thank you so much!!!! I did this and it was actually an issue with the Like *. With having so many expressions I had to put the Like * under the criteria and there were two on the same line that I had not noticed before. YAyy i'm so excited now I wont have to create a table and merge from the table I can merge directly from the query. :):D
 

dmarie2128

Thread Starter
Joined
Feb 1, 2013
Messages
5
Thank you so much!!!! I did this and it was actually an issue with the Like *. With having so many expressions I had to put the Like * under the criteria and there were two on the same line that I had not noticed before. YAyy i'm so excited now I wont have to create a table and merge from the table I can merge directly from the query. :):D
ok, so some how I was able to get this to work on my test query and now i'm not able to reproduce what I have done. I will continue to work on this until I can get it do work again.
 

dmarie2128

Thread Starter
Joined
Feb 1, 2013
Messages
5
what would be another way to do it if I want each column I have an expression in to show information? I was using the Like *, but that is causing an issue with the mail merge. Is there anything else I can use?
 
Joined
Jun 29, 2012
Messages
518
Only a question as I do not have time to play right now. Maybe field names without spaces might help? Sometimes having spaces can require an unusual amount of quotes to actually get recognized. Could be easy enough to test changing only a single field name. Just a thought.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
You could try a query as you have it and a second query based on the first one to actually transfer the data to the mail merge.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top