Results 1 to 2 of 2
  1. #1
    mhart is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    7

    Help needed with mail merge to Word

    I've designed my query, which is returning 45 records, but when I try to create a mail merge document in word, no records are there to merge. The merges worked fine while I was designing the database on my hard drive, but now that I've moved it to the network, I'm getting this error. I realized that moving the database might break the link to previous merges, so I created new queries and merges, but no matter what I do, zero records show up. This is a big part of what we use the database for, so I need a solution!



    Thanks,
    marilie

  2. #2
    mhart is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    7
    After much hair-pulling and cursing, I have figured out the problem. It doesn't make sense, but at least I can now merge from Access 2010 to Word 2010 without having to go through Excel. The problem was using wildcard characters to filter my query. Once I eliminated the wildcards, all of the records appeared in Word.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Mail merge with word
    By alexc333 in forum Access
    Replies: 0
    Last Post: 07-26-2011, 12:06 PM
  2. Mail merge from from Access to Word
    By williamgladstone in forum Access
    Replies: 1
    Last Post: 03-22-2011, 12:00 PM
  3. Click a Button to Run Word Mail Merge...
    By nchesebro in forum Programming
    Replies: 6
    Last Post: 03-09-2011, 01:41 PM
  4. Access Query mail merge to Word
    By Jan Collier in forum Access
    Replies: 8
    Last Post: 08-30-2010, 09:52 AM
  5. Mail Merge from Access to Word
    By Rachelkm2 in forum Programming
    Replies: 1
    Last Post: 05-29-2009, 02:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums