Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Mail merge within MS Excel 2000 (9.0.6926 SP-3)

    I have a worksheet that I wish to print out with names of 62 individuals prior to distribution. If this was a Word document I woould use the facility therein; Excel doesn't seem to have such.

    The data is in another worksheet. Can I `mailmerge' in Excel? And if so how?

  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: Mail merge within MS Excel 2000 (9.0.6926 SP-3)


  3. #3
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Re: Mail merge within MS Excel 2000 (9.0.6926 SP-3

    I'm sorry that you seem to have misunderstood.

    I am very capable of using an Excel database for a MailMerge to a Word document & often do so. What I want to do is use an Excel worksheet database as a source for a MailMerge to an Excel worksheet.

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

    Re: Mail merge within MS Excel 2000 (9.0.6926 SP-3

    Excel has no mail merge capabilities. You'd have to write code to loop through the 'records' of the data source and plug the 'fields' into the appropriate locations, then either print the workbook or save it under a new name.

  5. #5
    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: Mail merge within MS Excel 2000 (9.0.6926 SP-3

    I understood. And as Hans mentioned in excel it is not straightforward.

    My thought was to use excel in mail merge would be easiest to use the builtin capabilities of 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
  •