Prompt

Write a personalized email template for [describe purpose: e.g., a sales outreach, event invitation, newsletter] that will be sent to multiple recipients using mail merge. The email should include placeholders for the recipient’s Name, Company, and [other personalization such as Product or Interest]. Use a [friendly and professional tone] and make sure the content can apply to many recipients while still feeling personalized. The template should have: a subject line that catches attention (and includes a placeholder if appropriate), an opening line that uses the person’s name, body text that references their context via placeholders (like their industry or a recent interaction if you have that data), and a closing with your signature. Clearly mark the placeholders (e.g., {{Name}}).

How to Use

1. Define Your Inputs: Identify the data fields you have for each recipient. At minimum, you likely have Name. Common additional fields are Company, Title, Industry, Last Contact Date, etc. Also clarify the goal of the email (e.g., “to introduce our new service and encourage a signup” or “invite them to our webinar on X date”). Knowing your key message and call-to-action (CTA) is important before drafting.

2. Customize the Prompt: Fill in the prompt with specifics: the scenario (like “sales outreach for a new software feature” or “event invite for an upcoming conference”), the tone, and any particular points you want to include (such as a discount offer or a reference to how you got their contact). If you want the subject line to be generated as well, mention that explicitly. Also indicate the placeholders you plan to use, so the AI uses the same labels (for example, if your spreadsheet uses <<First Name>>, use that in the prompt instead of {{Name}}).

3. Optional Add-ons: You might ask the AI for a few alternate phrasings or even multiple draft emails to choose from. For instance, “Give two versions of the email: one more formal, one more casual.” Another idea is to have it suggest a P.S. line (which often grabs attention in marketing emails). If applicable, ask for a shorter snippet you can use as preview text (the bit that shows up in inboxes after the subject). Also, ensure compliance if needed – e.g., you could ask it to include an unsubscribe line if this is a mass mailing (though usually your email tool does that automatically).

4. Run the Prompt: Provide the prompt to the AI. It will generate an email template with placeholders where you indicated. Expect output that includes a potential subject line (if requested) and the body. For example: “Subject: {{Company}} – Quick question about your Q4 goals” and then “Hi {{Name}}, …” etc.

5. Review & Select: Carefully review the draft. Replace the placeholders with real examples in your head to see if it still reads well. Check that the tone is appropriate for your audience and that it doesn’t accidentally sound like a form letter. Ensure the placeholders are correctly labeled and match your mail merge system’s requirements (you might need to adjust {{Name}} to whatever syntax your system needs, like <<Name>> or %Name%). Verify the CTA is clear and that the length is reasonable (usually shorter is better for cold emails). If something is off – maybe the AI assumed a detail you don’t actually have – edit that out. You might iterate with the AI if you need changes (e.g., “make it more concise” or “add a line about how we got their contact info”). Once satisfied, use this template in your mail merge tool.

6. Expected Outcome: A polished email template that can be sent in bulk but feels personalized to each recipient. It will address each person by name and potentially reference their company or other specific info, which is proven to increase engagement compared to generic mass emails. For example, instead of “Dear customer,” it might say “Hi John,” and mention “at Acme Inc.” in the body. By preparing this through AI, you get a well-written base that you can then mail-merge with your spreadsheet of contacts. There are even AI-powered extensions for Google Sheets/Excel that can help scale this personalization across thousands of rows. Overall, you’ll achieve a mail-out that has a personal touch for each recipient, enhancing the likelihood of response, without having to manually write each email from scratch.