open new message from template

shmu · #1 04-21-2015, 05:50 AM

I want to send out 100+ messages, one after another, based on a email template. To each message I will manually insert a personal name and an email address.

(mail merge isn't a good option for me because the email account is gmail, and they put a daily limit on mass mailings)

I know how to create the template, and to access it from the developer tab.

question is: can I get a one-click way to open a new email message based on a specific template? To do it the regular way from the developer tab takes so many clicks, it almost isn't worth it. It's just too slow. I need a one-click method to open a new message based on a template.

any ideas?
I thought of recording a macro, but apparently you can't do that anymore in the modern versions of outlook. and I don't have the skills to write a macro in visual editor.

maybe I could alter the default template that outlook uses for new emails?
then I could just click on new email, and I'm all set.

If this is doable, please tell me how to do it, and how to get it back to normal again, afterward.

thanks...

okay, I think I found some answers on this blog. Doesn't sound too hard, after all.

https://www.ablebits.com/office-addi...outlook/#theme

gmayor · #2 04-21-2015, 06:48 AM

I can't see how mailing 100+ messages individually is going to be any different from using mail merge to mail 100+ messages?

http://www.gmayor.com/ManyToOne.htm in one to one mode will allow you to merge to e-mail with personalised messages - even different subjects if you wish, or you could merge as an attachment with or without a personalised covering message.

The only proviso is that the data source must be an Excel worksheet.

However you can create a message in Outlook and save the message as a template and create 100+ separate messages from that template if you have the time and inclination.

The following macro run from a button on the ribbon or QAT (Quick Access Toolbar) or keyboard shortcut will open a new message using whatever you have saved as the template as its basis. Change the file path and template name as appropriate.

Code:

Sub CreateFromTemplate()
Dim olItem As Outlook.MailItem
    Set olItem = Outlook.CreateItemFromTemplate("C:\Path\My Template Name.oft")
    olItem.Display
lbl_Exit:
    Set olItem = Nothing
    Exit Sub
End Sub

shmu · #3 04-21-2015, 06:54 AM

"I can't see how mailing 100+ messages individually is going to be any different from using mail merge to mail 100+ messages? "

gmail does treat it differently. you can send a zillion individual messages, but not if you use a mail merge method. It's an anti-spam thing.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to open embeded document when no message	davidpe	Word	1	02-23-2014 11:40 PM
Auto message box on open (when using template)	Drizz	Word VBA	12	04-25-2013 02:37 AM
Unable to open Outlook, receiving message unable to open because (myaccount)@gmail.c	Flyin' Aces Tattoo	Outlook	0	04-20-2013 11:56 AM
Message from template not saving	nigh	Outlook	0	01-11-2012 03:11 AM
Pop Up Message on Open	Emma Samm	Word	0	12-20-2010 02:38 PM