Inspire a Nation
Business Mentoring


Library Items

Use Google Chrome for the best experience with our website


WARNING! EFFECTIVE 7/15/2021 STOP USING BITLY AND OTHER LINK SHORTENERS - GOOGLE AND GMAIL ARE BLOCKING THEM DUE TO SPAMMERS AND SCAMMERS USING THEM. REMOVE ALL BITLY LINKS FROM EMAIL TEMPLATES AND EMAIL SIGNATURES AND REPLACE THEM WITH THE ORIGINAL SOURCE URL 


HOW TO BUILD A $10 MILLION REVENUE INSURANCE AGENCY – USING AN ASSEMBLY LINE APPROACH

July 15, 2021 Recorded Biweekly Mini-Workshop Session located on Biweekly Mini-Workshop Page, Module 1, and the Assembly Line Stations Page




Microsoft Word - Excel Email Merge: The Forgotten Marketing Tool

Mon, October 26, 2015 10:05 AM | Billy R. Williams, PhD. (Administrator)

With all the fancy technology and social media tools available today it is easy to forget the basic marketing tools and processes that have been used to create many millionaire business owners.

I want to take a moment and dust off one of those processes . . . The Word, Excel Spreadsheet, Outlook, email merge.

   

 

Click here to download a screen capture document that explains (in pictures) how to perform a Word, Excel Spreadsheet, Outlook, Email Merge.

If you want to send a document to many people via email, but you want it to be personalized (such as ensuring each person is addressed individually), use Word/Excel/Outlook for an email merge. In other words, each message you send out has similar language but certain parts of the message are unique and personalized.

An example of this might be an auto insurance renewal that’s coming up for prospects, and their current insurance company is taking a rate increase. You want to send out a marketing email to each person — all 170 of them that has information such as their current vehicles, x-date, current insurance carrier, and the producer they worked with in the agency.


An example email would go something like this:

“Hi Bob. This is Billy with the BMS Insurance agency. We spoke in June about your auto insurance, but you decided to stay with the ???? insurance company. According to our records your 2015 Toyota Camry is coming up for an auto insurance renewal on Jan 15, 2016. Our records also show that your current insurance provider, ???? insurance has filed for a rate increase that could impact the rates you currently pay. Bob, I hope you will take a moment and allow me to review your coverage options and compete for your insurance before you possibly pay more money without getting a second opinion.”

As long as the personalized information underlined is provided under a column on the spreadsheet, you can merge it into the email.

Use Word, Excel, and Outlook to send out an email to each of them, addressed and personalized, just to—and for—them.

(Active members can locate more detailed training in the Automation and Technology section of the Video Library)

Click here to download a screen capture document that explains (in pictures) how to perform a Word, Excel Spreadsheet, Outlook, Email Merge.

 

Provided as a courtesy by

Dr. Billy R. Williams

President - Inspire a Nation Business Mentoring

www.inspireanation.org

 

If you like the information and wisdom we share with you, please share it with your friends by using one of the following share buttons!

 

   



Active Member Training: The 1st and 3rd Thursday of the month at 12:00 PM Central (1 PM Eastern, 11 PM Mountain, 10 AM Pacfic).

All live sessions are recorded and available 24 x 7!

UPCOMING TRAINING TOPIC:

Missed a previous session? No Problem! Click on the Workshop Button to View Recorded Sessions




© Inspire a Nation Business Mentoring


PO Box 2115, Mansfield, TX 76063


For the fastest response Text your First Name, Last Name, and Question to our central message center at 682-206-3836

(Why a text message? Our team is always on a call or video web meeting supporting our mentoring members. A text allows us to contact you at our earliest opportunity)

 

Email: helpdesk@inspireanation.org


Website Privacy Policy and Video and Document Library Terms of Use

 

Powered by Wild Apricot Membership Software