Results 1 to 6 of 6

Thread: Mail Merge

  1. #1
    2 Star Lounger
    Join Date
    May 2006
    Location
    Portland, Oregon, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good Morning. Trying to perform a mail merge using a Word 2002 template and an excel spread sheet. I'm not using the wizard, but the Mail Merge tool bar. The second button from the left "Open a data source", browse to the excel spread sheet, double click and get a message "unable to open data source." I cannot understand why?
    Excel spread sheet is not open at this point. It lives in "My Documents" on C. It is not protected in any way.
    Any help out there?????
    I do have "print area" defined.
    Thanks.
    Charlotte Quiroz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You might try the following:
    - Select Tools | Options...
    - Activate the General tab.
    - Tick the check box "Confirm conversion at open".
    - Click OK.
    - Now specify the Excel data source again.
    - You'll get a dialog with several options to open the data source.
    - See if another choice than the one selected by default works.
    - If not, the Excel worksheet may not be set up correctly.


  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Charlotte,

    In Excel, go to Tools|Options|General and make sure 'ignore other applications' is NOT checked.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    113
    Thanks
    3
    Thanked 6 Times in 6 Posts
    There are several ways to merge Excel 2002 documents into Word documents, including ADO, conversion to Word, and DDE. I have had by far the best results with DDE. It may be old, but it works better than any of the others, and is blazing fast on Windows NT, 2000, and XP.

    David Gray, Chief Wizard
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Quote Originally Posted by David Gray View Post
    There are several ways to merge Excel 2002 documents into Word documents, including ADO, conversion to Word, and DDE. I have had by far the best results with DDE. It may be old, but it works better than any of the others, and is blazing fast on Windows NT, 2000, and XP.
    Hi David,

    The question of which connection method is best depends on the situation. DDE is useful, but has its limitations, just as the other methods have their's. Charlotte's problem was with establishing a connection in the first place, as indicated by the message "unable to open data source."
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  6. #6
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    113
    Thanks
    3
    Thanked 6 Times in 6 Posts
    Quote Originally Posted by macropod View Post
    Hi David,

    The question of which connection method is best depends on the situation. DDE is useful, but has its limitations, just as the other methods have their's. Charlotte's problem was with establishing a connection in the first place, as indicated by the message "unable to open data source."
    I understand, and I've had that problem when I tried to open an Excel data source as an ODBC data source. I've had no such problems with DDE conversations.
    David Gray, Chief Wizard
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

Posting Permissions

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