How to Write an Excel Macro and Send a Broadcast Email
How to write an excel macro and send a Broadcast Email
- Create or acquire the Excel file that contains the email addresses from the Treasurer or from the tiretirees.org website.
- Open the Excel file and highlight the email addresses you want to go into the email. Highlight ONLY email addresses. You can hold down the Ctrl key and left click to select the names to be included in the email.
- Click on “Tools”, then “Macro”, then “Macros”.
- In the “Macro Name” box, type the name you want this macro to have, then click create.
- When the Microsoft Visual Basic page comes up, highlight the: “ Sub test()…End Sub” block and replace it with the contents of the “Excel email club macro.doc” file.
- Then click “File”, then “Close” and “Return to Microsoft Excel”.
- Make sure the items you highlighted previously are still highlighted.
- Click “Tools”, then “Macro”, then “Macros”.
- Select the “mailto_Selection” and click “Run”.
- You will get a pop-up box that shows you the email headers and subject and greetings lines.
- Click “OK” and your email will be formed.
- Write your email and modify the “Subject” as necessary.
- In order to keep the email addresses confidential, we need to move all of them from the To: field to the Bcc: field, which doesn't always show up. If the Bcc field is missing, click on the To: button and your address book will come up. Add some name to the Bcc list - any name. Now click OK. The Bcc should now show on the email form.
- Right click in the middle of the To: email addresses window.Right click the Select All.
- Right click in the middle of the To: email addresses again and this time left click on the cut button. All the address should disappear from the To: window.
- Now highlight the email address that is showing in the Bcc: field. Right click on it and then clickPaste. All the addresses should now show in the Bcc: address window.
- You should add an email address to the To: field to make Outlook Express happy, so you can add if you like.
- You can edit the subject and greeting, as well as type or copy your message into the body of the email.
- Send the email.