Bulk Auto Emailer with Picture Signature and HTML body

The Bulk Auto Emailer with Picture Signature and HTML body is a VBA tool that automates sending professional, personalized emails in bulk from Excel. It is built for businesses and teams that email customers, clients or colleagues. Each message gets a branded HTML email body and your Outlook signature, including a picture, added automatically, so you save time without losing quality.

Key Features

HTML-Formatted Email Body

Design your email body with HTML tags to create well-structured emails with custom fonts, colors, images and links. HTML formatting keeps every email polished, professional and in line with your brand. It works well for product promotions, updates and personalized reports.

Automatic Picture Signature

The tool adds your Outlook signature to each email automatically, so every message carries the same professional brand presence. It supports a picture signature, so you can include a company logo, a team photo or a signature image in every email.

Selective Email Sending with the Skip Column

Each email entry has a Skip column that lets you choose whether that email is sent. Use it to hold back certain emails, send only to specific customers, or avoid contacts that don’t have complete data.

Preview Mode: Send or Display

You can switch between “Send” and “Display” modes. Display lets you preview each email and check its content before anything goes out. When you are happy with the result, switch to Send.

Email Personalization

Add customer details such as names, service data or unique identifiers, and each recipient gets an email written for them. This makes customers feel valued for invoices, service details and promotional offers.

Bulk Email Sending

Bulk email sending works in just a few clicks. Load your list of customer emails, enter the relevant data for each person, and generate and send multiple emails at once. You no longer need to send emails one by one, and you can reach large groups of customers or clients consistently.

Excel Integration

Excel is the input platform. Keep a database of customer names, emails and service information in Excel and update it whenever you need to. You don’t have to re-enter data each time you send, which helps businesses with large customer lists or frequent updates.

Benefits at a Glance

What’s Inside the Tool

• Excel data sheet to hold customer names, email addresses and service information
• HTML email body template that you can format with HTML tags
• Skip column to include or exclude individual emails
• Send / Display toggle to preview or send emails directly
• VBA automation that adds your Outlook signature, including a picture, and sends the emails in bulk

Who It’s For

• Businesses that send invoices, service details or customer updates
• Marketing teams running email campaigns that need to look on-brand
• Teams sending personalized messages to clients or internal team members
• Anyone who wants an automated email tool built on Excel and Outlook

How to Use It

1. Download and unzip the file, then make sure macros are enabled before use. For step-by-step instructions on enabling macros in Excel, see this tutorial: https://www.pk-anexcelexpert.com/4-easy-ways-to-enable-macros-in-excel-vba/
2. Enter or paste your customer data, such as names, emails and service details, into the Excel sheet.
3. Write your HTML email body and the personalized fields you want to include.
4. Mark any rows you want to hold back using the Skip column.
5. Choose Display to preview the emails, then switch to Send to deliver them in bulk with your picture signature.

Watch the step-by-step video tutorial:

Click here to read the detailed blog post about the Bulk Auto Emailer with Picture Signature and HTML body.

Visit our YouTube channel for step-by-step video tutorials: Youtube.com/@PKAnExcelExpert

Frequently Asked Questions

Does the tool add my Outlook signature automatically?

Yes. Your Outlook signature is added to each email automatically, and it can include a picture such as a company logo, team photo or signature image.

Can I format the email with HTML?

Yes. The HTML email body supports HTML tags, so you can use custom fonts, colors, images and links.

Can I preview emails before sending them?

Yes. Switch to “Display” mode to review each email. When everything looks right, switch to “Send” mode.

How do I stop certain emails from being sent?

Use the Skip column. Mark any entry you want to hold back, and the tool will skip that email.

Where does the customer data come from?

The customer data comes from Excel. You keep names, emails and service information in the sheet, and the tool uses that data to personalize every message.

Do I need to enable macros?

Yes. This is a VBA tool, so macros must be enabled after you download and unzip the file. The tutorial link in the steps above shows you how.

Also check our Download Attachments from Multiple Emails Automatically using VBA

Last updated: October 2026