Using a Macro to Respond to Emails with a Template | Everyday Office

Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:

Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.

[Blackpoule]

I took 10 minutes to watch and rewatch this video. It will save me HUNDRED of clicks, of ctrl-c / ctrl-v and shit tons of time in the future. You sir, are amazing.

[haveagoharry]

So helpful, thanks for the clear and precise instructions, this will save so much time!!

[delgadoii]

This was very helpful, thank you for taking the time. Much appreciated. 🙏

[mihaiATB]

Hi, this template is something I was looking for a long long time - thank you so much!
However, for me it seems to be working only on the day I'm creating it, next day the button (command) is no longer working. Is there a setting I should take into consideration for this to stick indefinitely?

[doblejj]

Really really helpful. thanks a lot for the time you took to make this video.

[francescabadini]

Really helpful macro. It makes my work easier. Is it possible to also reply with the original attachments of the email?

[EmreYasinAlbayrak]

what the easiest way this is. Thank you so much

[polovladimir]

Followed all the steps but template is not launching when button is pressed, can someone help me please?

[sagarananthashayana]

How to forward an email to specific email recipients with attachment

[kaibalyasahoo]

It is for one email if we need to send reply to multiple emails reply

[zubarmalik]

Can you show how the first example. Ger errors when loading it

[Tat-cxlr]

I used your macro. It’s work but the logos present in my signatory do not appear. Can you help please. Merci beaucoup.

[noelledillenburg]

I used this macro but the only issue I am having is that if there are more than one names in the "To" field it only replies to the first email name and does not include the other names in the To field. How do I update the code to reply to all of the names in the To field?

[dhawalghia]

Hi team, thanks for this video. I need one help. If some one sends me a request and i want to send him an auto email reply saying "Hi we have ack the receipt of your mail. Someone from the team will revert on your request. Kindly note the ticket number 0001" can we automate this and once the ticket is closed then he will get the email "Hi your ticket number 0001 has been closed". How can we do this using excel and outlook ?

[lindacharlton-gunderson]

I got the first micro to work but when I tried to add another email template the second one did not work. Do you need to create another Project? I just added a new sub and end sub for the second template what did I do wrong?

[noeadrias]

How to add a default cc sample all of the team members address?

[christfollower]

This is great and it works but what if I need to create multiple templates? How do I add? Please and thank you

[monicatompkins]

How can I get this macro to work automatically for all emails that I receive? as opposed to having to select an email and then using the special button in the customized ribbon? I want to auto-reply to all emails with a special template. When I use the rule, the auto-reply loses all the formatting. This macro works as it preserved the HTML format. But I want this to be used for each email I receive automatically, without me having to click on the email and then select the button within the "special responses" group that we've just created.

[ManuelSilva-dloq]

Great video. Done everything as you said but the following erro occures. How can I solve it?

"The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros."

[julianchan]

I set up the Macro step by step according to your video, but when I click the button, nothing happens, may I ask what might be the problem?
The file location & name area are like this