I am familiar and have used Word mail merge with a query from Access for my data. I have created a query that lists 15 names and addresses. when I go to create the mail merge the query data does not populate. Other queries populate fine. Help please
I am familiar and have used Word mail merge with a query from Access for my data. I have created a query that lists 15 names and addresses. when I go to create the mail merge the query data does not populate. Other queries populate fine. Help please
you can always view the internal access report, then click SENT TO:
or
event setup a list of recipientsin a form and cycle thru them sending the report.
When this query was created it was just like the hundreds of other queries I have created and used for the source of my mail merge. The "Mail Merge Recipients" dialog box has the correct column headings...it is just not populated with the data from the query. Why?
Would have to analyze design and code. If you want to provide files, follow instructions at bottom of my post.
Why so much use of mail merge? Why not reports in Access?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The entire database is confidential so I am reluctant to send it out.
If I convert the query to a Exell spreadsheet then I can use that as my source for the mail merge. However, I have never had to do that extra step to complete a mail merge. I'm stumped.
You could purge confidential data.
I doubt anyone can determine cause of issue without some frame of reference - need to analyze data, design, code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I have found that when I use the word "like" in a criteria expression the data source does not populate the "Mail Merge Recipients" dialog box. Conversely, when I do not use the word "like" the data populates as it should. I think there is something foul in the Word program that cannot work with the word "like" in the query data source. I am stumped.
See, if you had provided that query in your OP, probably could have verified that long time ago. Just tested and confirmed. LIKE and * wildcard do not work.
Possibly only options are to figure out some other criteria to pull records or write them to a temp table and use that table as source for the merge.
Back to my question - why mail merge? Why not email from Access?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes, in a previous post I said converting the query to an XL spreadsheet works as the data source. I feel that if Microsoft would correct their program I woudn’t have to go to this extra step. Does Microsoft know of this problem? Can we get them to correct it?
Reguarding your other ? Our data is not complete with emails but it is complete with street addresses.
I appreciate your help very much. Thank you.
Get Microsoft to change the program - not likely.
No need to involve Excel.
What do street addresses have to do with this issue?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
This is a donor database. Not all donors provide their emails but they all provide their street addresses so we communicate with snail mail.
Please explain “no need to involve Excel”.
As I already suggested, if you need to use LIKE and * wildcard then write records to a 'temp' table and use that table as source for the mail merge. No need to export to Excel.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.