Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2011
    Location
    Portland, OR
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry Mail Merge from Access Queries no longer work

    I use Access and Word 2010 in Windows 7. I have a number of mail-merge letters I use for a nonprofit organization. These have worked just fine for years, until a few months ago. Now, I can no longer merge from Access queries directly. The queries still work fine, and I can export them to an Excel spreadsheet and use the spreadsheet as my data source for the merge, but that adds several steps and must be reconstructed every month. Any ideas as to why Word can't find data in Access queries anymore?
    Last edited by ruirib; 2012-11-03 at 15:08. Reason: Moved to word processing as the problems seems to be with Word and not Access

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    What version of Access were you previously using? Beginning with Word 2002 the mail merge process was revised completely and parameter queries no longer worked as they had previously. See All queries do not show up when mail merging for a more detailed description of the issues and the workarounds.
    Wendell

  3. #3
    New Lounger
    Join Date
    Feb 2011
    Location
    Portland, OR
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wink Merging from Access 2010 to Word 2010

    The revelation that I couldn't use * as a wildcard in my query was the key. I changed 11/*/12 to "between 11/1/12 and 11/30/12" and my merge documents worked just fine. I still do not understand using OLE DB wildcards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •