Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jul 2006
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a spreadsheet (Excel 2003) containing the names of members of staff, their departments and managers - see attached for abbreviated version of the file.

    I need to send an email to each Manager showing staff details of the people reporting to them. I have created a MailMerge document (to send to email messages) but this sends one email for each member of staff - so in the case of Manager "Fred Bloggs", he would receive six emails as he has six members of staff. What I am trying to achieve is one email per Manager - format something like this, with data preferably in a table.

    Dear Fred

    Please confirm that these members of staff report to you:

    First Name Surname Grade Department Manager Current Salary
    Liz Abraham 5 Production Fred Bloggs 8,304.00
    Tony Carter 5 Production Fred Bloggs 9,552.00
    Tom Griffith 1 Production Fred Bloggs 6,192.00
    Tim Metzer 2 Production Fred Bloggs 10,704.00
    Meg Pope 1 Production Fred Bloggs 9,288.00
    Nick Yoshi 1 Production Fred Bloggs 9,288.00

    If anybody has any ideas as to how I can achieve this, I would be very grateful.

    With many thanks in advance
    Attached Files Attached Files

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    I don't do enough merges to help myself, but you should check out this thread, which hopefully will get you to the next phase: [topic=731107]Word 97-2007 Mailmerge Tutorial: Create Sorted Listings (v1.52)[/topic].

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,497
    Thanks
    3
    Thanked 42 Times in 42 Posts
    The catalog merge idea that Jscher2000 is one way of accomplishing that. However we tend to use Automation to do these kind of things, and store the data in a database rather than Excel. If you are interested in that approach, check out our tutorials on Automation and Automated Merges. Using the latter approach, we often create some 800 separate Excel workbooks, and then email them to the appropriate persons.
    Wendell

  4. #4
    Lounger
    Join Date
    Jul 2006
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you very much for these ideas. I'll let you know how I get on.

Posting Permissions

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