Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge Query (2000)

    I'm helping someone with Office 2000. We are merging address labels from an Excel file. We need to select records using the Query, but there is no "contains" choice. Any idea how to add "contains" to the list of comparison options? TIA, J

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge Query (2000)

    <post#=128577>post 128577</post#> has information on the different options when merging from an Excel datasource. If your datasource is the first spreadsheet in the Excel file, then select the DDE method of merging. In the mailmerge helper dialog box, you'll see an Query Options button & you can use that to make your query.
    Hope this helps,

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge Query (2000)

    Thanks, but I guess my question wasn't clear enough. I am able to link the single page spreadsheet for the merge using Tools, Mail Merge. Where I run into trouble is the Query Options. There are multiple single letter codes in a field and I want to select the records based on "Contains" "A," . But the problem is the only choices in the comparison column are Equal to, not equal to, Less than, Greater than, ,,,is blank, is not blank. There is no comparison choice for "Contains". If I use equal to A, that works for records with only one code. But there are codes like A,M,T, So the only way I can think of to best select records is if I could choose CONTAINS A,. So I'm looking for a way to add "Contains" to the Comparison choices. Thanks again, J

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge Query (2000)

    Hi J:
    In that case, do the following:
    Tools/Mailmerge.../Create.../Mailing labels...
    Get Data/Open Datasource/<big><font color=red><code>MS Query</code></font color=red></big>

    If you follow through with Excel database, this will eventually let you choose a field & use "Contains".

    Post back if you need more information.

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge Query (2000)

    Thanks Phil I followed along the steps for MSQuery and was able to use the Query Wizard to filter the data specifying Contains A, but when I get to the last step which has a radio button selected as "Return Data to MS Word" and click the Finish Button, I get a message: "Word was unable to open the data source." When I choose the other radio button which is View Data or Edit Query in MS Query and click the Finish button, I see a table with the correctly filtered records, but the only place from there that I could see to get it to merge with word was a choice under the file menu, "Return Data to MS Word" I get the same message: "Word was unable to open the data source." Thanks again, J

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge Query (2000)

    Yeah, I find it's buggy. Sometimes it can't find the data source & sometimes it can't find any tables in the data source. Try this:

    Tools/Options/Mailmerge..

Posting Permissions

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