Results 1 to 2 of 2

Thread: Form leter (XP)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Monroeville, Pennsylvania, USA
    Thanked 0 Times in 0 Posts

    Form leter (XP)

    I am trying to build a form letter (mail merge) using EXCEL as a source for the information. The problem I am having is that I can only use one work sheet for the source information. The spreadsheet uses sheet 1 to store names and addresses. and sheet 4 to store the numbers that need to be inserted. How do I set up the mail merge to allow two different sources within one workbook?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Form leter (XP)

    Word does not support merging from different sources. You will have to create one worksheet that contains all the data you need. You can use formulas referring to another worksheet to build it.

Posting Permissions

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