Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    merge mail prob. (XP)

    I have a problem retrieving data from a query when trying to get recipients info into a mail merge doc.
    I have carried out a query, successfully, to show only customers whose surname begins with "M".
    Then When I try to find that info while creating my mail merge doc. by clicking on browse, there is no data displayed in that query.
    The query I ran was ( Like"M*" ) That part was successful. And gave me the list I requested.
    But.....I cant get that data into my mail merge doc. It keeps coming up empty!! Soooo...frustrating. Have no idea what I am doing wrong.

    I find I can get the results I am looking for by doing an advanced filter which is a long way to go about this but I feel there must be away I can still do this job using a query.

    I hope someone out there will understand what I am trying to explain and be able to help me on this one.

    Cheers. Sylvie

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: merge mail prob. (XP)

    When you select the query as data source in step 3 of the mail merge task pane, can you see the data, like in the screenshot below, or does that come up empty too?
    Attached Images Attached Images
    • File Type: png x.PNG (18.9 KB, 0 views)

  3. #3
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: merge mail prob. (XP)

    Hi Hans,

    Thanks for coming to my rescue. I appreciate your time.

    Yes. That mail merge task pane you show me below comes up empty of all data. But only for this particular saved query.Yet all the data is still there when I open the query in Access. The query I ran worked. I just can't seem to merge it into my mail merge doc.I have had no probs. with any of my other queries from this data base when using them in mail merge.

    Any ideas?? Here's hoping.
    Sylvie

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: merge mail prob. (XP)

    Could you do the following? Thanks in advance.
    - Open the query in design view in Access.
    - Select View | SQL
    - Copy the SQL text you see to the clipboard (Ctrl+C)
    - Paste it into a reply in this thread (Ctrl+V)

  5. #5
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: merge mail prob. (XP)

    Thanks Hans,

    Here is the copy of SQL text you requested.

    SELECT [names test].ID, [names test].Sname, [names test].fname, [names test].address
    FROM [names test]
    WHERE ((([names test].Sname) Like "M*"));

    I hope you have some joy and thanks for trying.

    Sylvie

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: merge mail prob. (XP)

    OK, thanks. The default method of connecting to the database doesn't support queries using * or ? as wildcards. See No Records Are Displayed When You Merge Data with Microsoft Word.

    Instead of the method recommended in the MSKB article, I prefer this workaround:
    - Select Tools | Options...
    - Activate the General tab.
    - Tick the "Confirm conversion at Open" check box.
    - Click OK.
    - Now, continue to step 3 of the Mail Merge Task Pane again, and click Browse...
    - Navigate to, and select the Access database containing the query.
    - A Confirm dialog will be displayed in which you can select the method to connect to the database.
    - The default in Word 2002/XP is OLE DB. You don't want this. Select the DDE or ODBC option, and click OK.
    - If you selected the DDE option, activate the Queries tab of the next window.
    - If you selected an ODBC option, click Options..., and tick Views, then click OK.
    - This will allow you to select the query.
    - Continue as usual.

  7. #7
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: merge mail prob. (XP)

    Thank you so much. I will give that a go. The service you provide to novices like me is invaluable and greatly appreciated.
    Cheers.
    Sylvie

  8. #8
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: merge mail prob. (XP)

    Thanks Heaps and gobs Hans,

    Joy, joy. Happy, happy. Tried it and it works.

    Cheers Sylvie

Posting Permissions

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