Sending Bulk Automated Emails Using ThunderBird with VBA (Easy VBA/Work Automation)

You must install Thunderbird and log in before using this program.



Title: Using ThunderBird with VBA to Mass Send Emails (Easy VBA/Automation Even Your Dog Can Do) After Getting Fed Up With Outlook
I recently got super frustrated with Outlook and couldn't get my Google account to log in no matter what, so I needed to find an easy way to mass send emails for work. I figured Excel VBA would be the way to go, but Outlook is such a pain to use. I found that ThunderBird integrates really well with VBA, so I decided to create my own automated email solution.
The key points:
I made this because Outlook sucks and I was tired of the hassle of manually sending emails one by one.
ThunderBird is a lot lighter and more user-friendly than Outlook, which is why I chose it.
This VBA script is designed to be super simple - even a dog could do it with a little bit of effort. No complicated Outlook object setup or anything like that.
I focused on making it easy for anyone to use, even if they don't have much VBA experience. Just follow the steps and you'll be cranking out mass emails in no time.
The script can handle things like sending different files to different recipients, which is great for things like payroll, invoices, dunning letters, etc. No more tedious manual work.
Experienced Excel/VBA users can also dig into the code and formulas to customize it for their specific needs. Hopefully it gives you some good ideas!


### Quick Guide (VER 1.1)

1. **Version Overview**:
- Version 1.1 is great for sending individual emails. You can copy from the specs tab next to it for better usability.

2. **Recipient Address**:
- For sending to more than one person, separate the email addresses with commas.

3. **CC Address**:
- Leave it blank if not needed. Multiple addresses can also be separated with commas.

4. **Subject**:
- Straightforward.

5. **Body**:
- HTML tags (like `<BR>`) can be used and will display correctly in the email.

6. **Reset Attachments**:
- Clears any existing files. Hit this before starting a new email with attachments.

7. **File Attachment Button**:
- Click to choose files to attach. Selected file names and paths will automatically show in the attachment list. Attach as many files as needed.

8. **Manual Send Button**:
- Clicking this takes you to Thunderbird’s external mailbox. Thunderbird needs to be running to send emails.

9. **Auto Send Button**:
- Choose this for immediate email sending.

---

### Quick Guide (VER 2.1)

1. **Version Overview**:
- Version 2.1 is handy for sending pay stubs or monthly bills to different recipients. Set it up once and use Excel’s find-and-replace feature to update filenames monthly.

2. **Formulas**:
- Similar to version 1.1; avoid altering them unless you’re confident.

---

### LIST OF MAIL

1. **Function**:
- This tab pulls info from the 'Mail List' tab to send emails. Use the manual and auto send buttons on the right.

---

### Mail List Tab Screen

1. **Sequence Number**:
- Indicates how many emails you’re sending. For 20 recipients, use numbers 1 to 20 in order. Delete skipped numbers.

2. **Recipient Address**:
- Separate multiple addresses with commas.

3. **CC Address**:
- Same as above; use commas for multiple addresses.

4. **Subject**:
- Easy to fill.

5. **Body**:
- Straightforward.

6. **Attachment List**:
- Attached file names appear automatically.

7. **Attachment Paths**:
- Paths populate automatically. For multiple files, separate with commas. Use commas if entering manually.

8. **File Attachment Button**:
- Select files to attach.

9. **Reset Button**:
- Press this before starting a new email with attachments.

10. **How Attachments Work**:
- Correct paths separated by commas ensure proper attachment. Reset old paths for new emails.

11. **Miscellaneous**:
- For monthly statements, set up once and use Ctrl+F to update the month in file paths. Correct paths ensure attachments work.

---

### Feedback

- If you have questions or suggestions, feel free to comment. I’ll do my best to incorporate your feedback!