Painless Mail Merge via email

Discussion in 'OS X and OS X Apps' started by ricocamus, Nov 9, 2006.

  1. ricocamus

    ricocamus Member

    Joined:
    Apr 11, 2006
    Messages:
    828
    Likes Received:
    23
    I'm so pleased with myself I thought I'd share my discovery.

    I teach a class and twice during the term I email out the test results and class standings to my students. Its usually a standard form letter type that says " your mid term grade is x and your recitation grade is Y". As I was doing this manually last term for a class of about 35 students, it occurred to me that there should be a way to automate it. I told myself that this term I would work on figuring it out.

    Since I maintain the grades of the class in an Excel spreadsheet, I thought it shouldn't be that difficult to use that as a database and create a mail merge document in Word. Back in the old days of Wordstar (remember that program?) it wasn't that hard to create multiple form letters using the mail merge function. So a little research in Microsoft Word and I found that not only is the mail merge function built in to the program, but it also had a 'merge to email' option that outputs directly into your Entourage outbox for emailing.

    The Data Merge Manager under tools makes it a painless process in Word. What used to be a manual process of cutting and pasting grades into an email is now a 5 minute automated breeze!

    If you need to send out form letters by email, this is a wonderful tool. And everything is built into Microsoft Office. And surprise surprise, it actually works well.

    I am a happy camper!
     
  2. alfiesy

    alfiesy Active Member

    Joined:
    Apr 12, 2004
    Messages:
    1,021
    Likes Received:
    0
    Location:
    Makati City
    Thanks for the wonderful tip! Does this merge to email work only for MS Entourage or can it work with Apple Mail as well?
     
  3. ricocamus

    ricocamus Member

    Joined:
    Apr 11, 2006
    Messages:
    828
    Likes Received:
    23
    Only works with Entourage and you have to configure it as your default email client.

    Use the office help for a step by step walk through of how to set it up and use the mail merge function
     

Share This Page

  • About PhilMUG

    Since the mid-1990s, PhilMUG (formerly the Philippine Macintosh Users Group) has grown to become not just the Philippines’ but one of the world’s foremost Apple user groups. Our online community brings together thousands of members from the Philippines and around the world for the latest news and discussions covering all Apple products and related hardware and software. Anyone can join PhilMUG, from newbies to experts, subject to our membership rules and guidelines.
  • Like us on Facebook

  • Buy us a beer!

    The staff works very hard to make sure that PhilMUG is running 24/7. Care to buy us a beer or help out with our hosting fees? We'd really appreciate it!

    Donate to us!