How ca I  mass email from Outlook 2003 using an Excel database

Posted on 2008-11-14
Last Modified: 2012-05-05
A client of mine owns a hotel and has an excel database (Office 2003) containing the details of several thousand clients.

He wants to email a standard invitation email using Outlook to each one.

What is the best way to achive this?

Secondly, the database also contains Fax numbers for many clients - he wants to fax all these contacts as well.

Any recommended software for this?
Question by:chrisfixit
    LVL 50

    Accepted Solution

    For part 1) see Ron de Bruin's code to mail a message to all email addresses in a range,



    LVL 1

    Author Comment

    Thanks, but where/how do I create, run, this Macro?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    Outlook Free & Paid Tools
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now