This guide walks you through how to use MailerLite to send emails with unique activation links to each member, using a CSV file.
Step 1 – Create a Free MailerLite Account
-
Click Sign up
-
Enter your email address and create a password
-
Complete the account setup (you’ll need to verify your email and fill in a few business details)
Step 2 – Prepare Your CSV File
Your file should include at least the following columns:
First Name | Last Name | Activation Link | |
---|---|---|---|
Sarah | Dupont | sarah@example.com | https://yourlink.com/abc123 |
Save your file as a .CSV
Step 3 – Import Your Contacts into MailerLite
-
In MailerLite, go to > Subscribers
-
Click Add subscribers
-
Choose Import from a CSV or TXT file
-
Upload your CSV file and click on Import Subscribers
-
Match each column to the right field:
-
First Name →
NAME
-
Last Name →
LAST NAME
-
Email →
EMAIL
-
Activation Link → Create a New TEXT field called
ACTIVATIONLINK
-
-
Click Finish importing
Step 4 – Create a New Email Campaign
-
Go to Campaigns
-
Click Create campaign
-
Select Regular campaign
-
Enter a campaign name (e.g. Send Activation Link)
-
Click Next: Content
Step 5 – Design the Email
-
Choose Drag & drop editor
-
Add a Text block
-
Write your message and insert merge tags using the
#
Variable icon in the text toolbar:-
Click the
#
icon to open the list of variables -
Select your fields (e.g.
First Name
,Activation Link
) from the list
-
- Match your logo or customize the layout as needed
- Click Done editing
Step 6 – Send a Test Email
-
Click Preview & Test
-
Choose Send a test email
-
Send it to your own email to make sure everything looks right
Step 7 – Review & Send
-
Click Done editing
-
Review everything
-
Click Send now or Schedule for later
📌 Notes
-
MailerLite’s free plan allows up to 1,000 subscribers and 12,000 emails/month