How to send multiple custom marketing emails for your small business

For small businesses, independent traders, sole traders, entrepreneurs, and start-ups, personalized email marketing can help build stronger client relationships and boost your business. Follow these easy steps to send mass emails to clients using Microsoft Word and Outlook Mail Merge.

Step 1: Prepare Your Contact List

  • Open Microsoft Excel and create a spreadsheet with columns for the data you want to personalize (e.g., First Name, Last Name, Email Address).

  • Save the file in an easily accessible location as an .xlsx file.

Step 2: Start a Mail Merge in Word

  • Open Microsoft Word.

  • Go to Mailings > Start Mail Merge > E-mail Messages.

Step 3: Connect Your Excel Contact List

  • Click Select Recipients > Use an Existing List.

  • Locate and open your saved Excel file.

  • Select the appropriate sheet and click OK.

Step 4: Write Your Email Marketing Message

  • Write your email content directly in the Word document.

  • To insert personalized fields, click Insert Merge Field and choose fields from your Excel columns (e.g., First Name). – This will customise each individual email based on the data in your excel sheet!

Step 5: Preview and Finalise

    • Click Preview Results to review how your email will look for each recipient.

    • Make any necessary adjustments to your content and ensure that all of the emails function properly, as long as your contact database is populated properly, it will work fine!

Step 6: Send Mass Emails to Clients or Customers

  • Click Finish & Merge > Send E-mail Messages.

  • Enter the column name containing the email addresses (e.g., Email Address).

  • Add a subject line and choose the HTML message format for a professional look.

This is how it should look! (The name of the to: column may differ depending on your contact spreadsheet)

Step 7: Launch Your Campaign Click OK to send mass emails to clients through Outlook.

  • Click OK to send mass emails to clients through Outlook.

You’re all done! Outlook will now send emails to each and every individual in that spreadsheet, please bare in mind this is for small scale email marketing campaigns as Outlook and Mail Merge have a limit to recepients and mails per day. 

If you’re looking for larger scale Email marketing campaigns please get in touch with Nexus Lean and we can support this.

Tips for Successful Email Marketing for your Business

  • Ensure Outlook is set as your default email client.
  • Keep your Excel data clean and avoid empty rows.
  • Test with a small batch first before sending mass emails.
  • Try incorporating images and graphics to make your emails stand out
  • Use calls to action that resonate with your customers or target audience.

By following these steps, small businesses, independent traders, sole traders, entrepreneurs and start-ups can easily create and send effective email marketing campaigns using Microsoft Word and Outlook Mail Merge. Start personalising your client communication today!

FAQ: HOW TO SEND MASS EMAILS TO CLIENTS OR CUSTOMERS

What should I include in my marketing emails? It’s important to know what your goals are with each campaign, is it to reach out to existing clients and let them know of a new promotion or offer? Are you reaching out to a new audience who you have not communicated with yet? One thing that remains consistent is adding value to the recipient, try to help and solve a problem they may be having and it will increase the chance of engagement.

How can I make sure people open my cold emails? The subject line is key for your open rates, this going outside the box of typical marketing emails and using things like RE:, so they think they’ve opened your emails before or it’s part of an existing chain or something that grabs their attention like “You can’t miss this opportunity!”

How can I get started with email marketing, I don’t even have a contact list? A Contact list is essential ofcourse, try to look at previous correspondence you’ve had with customers via email or social media DM’s. Build your list from there. You can also integrate your contact form on your website with Google Sheets to enable automatic collection of contacts, if you’re not sure how to do this, reach out to Nexus Lean and we will help you.

By following this simple step-by-step you'll be equipped with the knowledge to send Email Marketing campaigns, build a contact list and grow your business through cold and warm outreach

HAVE NEXUS LEAN DEAL WITH YOUR EMAIL CAMPAIGNS

Free up more time to do the things you excel at by partnering with Nexus Lean to handle your digital outreach efforts. We create compelling emails and help integrate your website to build strong, relevant leads and contact lists.

GET STARTED

More value from nexus lean

How to write an effective Business Plan

Writing a business plan can feel like a big task, but it’s one of the most important steps you’ll take to get your business off the ground. Whether you’re starting a small business or a larger venture, a solid business plan helps you map out your goals, understand your market, and pitch your business to investors. In this post, we’ll guide you through the process of creating an effective business plan.

Read more >

How to set up your work emails on Outlook in 2024 (IOS & Windows)

Setting up your work email in Outlook using IMAP on your iPhone or Windows PC is essential for seamless access and productivity. This step-by-step guide walks you through configuring your email with ease, ensuring your messages are synchronized across all devices. Whether you’re a small business owner, entrepreneur, or startup professional, follow these steps to stay connected and efficient. For custom email solutions, visit Nexus Lean and elevate your business communication today!

Read more >

GROWTH+

Get a stunning One Page website that converts visitors into customers!

Stop looking unprofessional and establish authority with your business, project or idea. Stunning one page landing websites that showcase your work, sell your products and tell your story!

£100

Reduced from £450 !