Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word/Excel Merge (Office 2002 SP2)

    I have a database of addresses stored in Excel. The database has the autofilter on so I can choose addresses by category. Is there a way to perform a label merge in Word that would only include the filtered data from Excel?

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

    Re: Word/Excel Merge (Office 2002 SP2)

    Select Tools | Options... (in Word).
    Activate the General tab.
    Make sure that 'Confirm conversion at Open' is ticked, then click OK.

    When you select the Excel workbook in step 3 of the Mail Merge Wizard (task pane), you'll be asked which method you want to use to connect to the data source.
    Select 'Microsoft Excel worksheets via DDE (*.xls)', then click OK.
    Next. you'll be asked to specify a name or range. Select _FilterDatabase, then click OK.
    Continue as usual. You will notice empty rows in the data source (the rows hidden by the AutoFilter), but the default setting is to suppress empty records during the actual mail merge.

    Note: _FilterDatabase is a hidden named range that is automatically created when you activate AutoFilter.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word/Excel Merge (Office 2002 SP2)

    Thank you Hans! What a concise response.....works beautifully.

Posting Permissions

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