Jump to content
Macro Express Forums

I'm looking for a simple Mass Email Macro

Recommended Posts



I'm wondering if there is a easier way to send mass individual emails.


- Attaching 2 PDF file

- Changing the email address for each email.

- Changing the name in the content


Using the outlook?


Is there easier way to do this and not spend hours sending the emails....  using the macro?    


It's that time of the year where I would need to send out contracts to our clients....

Link to comment
Share on other sites

I have done this in MEP but I find using Mail Merge with the email method in Outlook to be much simpler. No need of creating a macro for an extant function.

Also mailing services like MailChip and Constant Contact will let you use their services for free up to a limit. For most people the limit is more than adequate. 

Link to comment
Share on other sites

Like Cory, I've written macros for tasks like these, but I've found built-in methods, like Mail Merge, usually accomplish much the same thing much easier.


If you don't want to use Mail Merge, there may be ways to semi-automate the process without using macros.


For example, prepare an outgoing message that includes the two attachments. Save it as a draft. Go into the "Drafts" folder. Copy the message, and paste it repeatedly until you have pasted in the number of messages you need.


You will still need to go into each message and insert email addresses. But if the number of messages is relatively small, these kinds of "tricks" significantly reduce the effort.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...