Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge 3 documents (Excel 97)

    I want to do a mail merge to Word but I have information on 3 separate Excel spreadsheets. Is there a way to do that? Thanks for any help.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Merge 3 documents (Excel 97)

    I don't use Word and MailMerge:
    BUT
    if this can NOT be done directly (maybe someone knows a direct way), you could create a single excel file which is LINKED to the other 3 files and then mail merge using the "combined" file. Changes made to the original 3 should be reflected in the combined file and thus in WORD.

    Steve

Posting Permissions

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