Friendly spam sender tool

VBA tool to send personalized template-based emails to the list of recipients via MS Outlook.

1. Copy this file to separate folder, rename it (optional) and open email sheet.
2. Choose Importance of emails from the dropdown box, fill the field From: if you have more than one active accounts in your Outlook and fill the Path to attachments: field if you plan to attach any files.

Please, keep in mind, that attachments will not be added to the emails if Path to attachments: field will not contain the full path to the folder with files!

3. Prepare email template (sections Subject & Body). Use curved brackets {placeholder_name} for placeholders you will replace by personal information - I.e. use {Name} versus John or Katty - you will add personal information later.
4. Prepare personal information block (starts from Row 22)
   a. Column B is reserved for recipient email address
   b. Columns from C reserved for the placeholders with 3 special names:
   СС- to fill CC section in email
   BCC - to fill BCC section in email
   Attachment - for files, to be attached to emails (files should be located in Path to attachments folder) for any other kind of information put the name of placeholder into the Row 22 (starting from column C) and values for each email below

IMPORTAINT! Macro will use Rows and Columns only before the empty cell - i.e. if you will keep cell [D22] empty, placeholders from Column E WILL NOT BE USED!

As a trick for rows you can place empty row BEFORE the recipients you want to skip for this session. I.e. you can put YOUR own email as the first recipient in line 23 and all real recipients starting from line 25 - line 24 should be empty (just insert the row before row 25). In this case you will be the only recipient and can check how your emails will look like.

5. Check all parts one more time and press Send emails button - you are done!

It's very importaint step, because you gonna send MANY emails at once! Use trick from 4b Note for testing first.

It's a good idea to send the letters with delay (in this case you will have a chance to check emails in Outbox folder of Outlook). You can set delay interval in minutes (up to 7 days = 60 * 24 * 7 = 10 080 minutes), hours (up to 14 days = 24 * 14 = 336 hours) or days (up to 30 days). Option added starting version 1.1

6. One of the scenario for this tool is to collect different information from a lot of sources. In this case you can use sheet reminder to send reminders on your initial request: a. Place all files you got from the answers to the folder stated in Sub-path to answers: - it should be subfolder INSIDE the folder with this tool
   b. Press Check answers button - it will copy ALL rows STARTING from 'row 22' from email sheet and REPLACE ALL the values you have put there before!
   c. If the file mentioned in column attachment from email sheet will be found in folder Sub-path to answers it will be counted as replay, and row with this recipient will be deleted from the list. As a result you will got the list of the recipients who didn't answer your email (OR you forgot to put these files into Sub-path to answers: folder, OR files were RENAMED)
   d. Prepare reminder template on sheet reminder - see steps 1-5 and press Send emails button - done!
   e. Repeat steps 6a-6d if necessary