Outlook Direct Mail Campaign

I need help running a one-off direct mail campaign in Microsoft Outlook aimed exclusively at our existing customers. The purpose is straightforward: promote our latest product line with a clear promotional offer—no product updates or case studies this time, just a compelling deal that drives immediate interest.

Here’s what I’m looking for:

• Contact preparation: import or clean my current customer list (CSV/Excel) and set it up as an Outlook distribution list or mail-merge data source.
• Email build: design a branded, mobile-friendly HTML email that spotlights the promotional offer, personalises each message with the customer’s name, and stays within Outlook’s rendering limits.
• Deployment: configure and execute the send from my Outlook account, scheduling in manageable batches to avoid send limits and spam flags, and handling any bounce-backs.
• Wrap-up report: a simple summary confirming total sent, failed addresses, and any read-receipt or tracking data you can gather within Outlook or an add-in of your choice.

All assets (template, cleaned list, and report) should be delivered back to me ready for future reuse. If you have proven Outlook mail-merge or VBA automation experience, let’s get this campaign out the door quickly.