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

[@Blackpoule420]

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.

[@haveagoharry4999]

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. 🙏

[@doblejj]

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

[@EmreYasinAlbayrak]

what the easiest way this is. Thank you so much

[@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?

[@francescabadini1380]

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

[@gughanraju5681]

clear and precise...thank you

[@polovladimir]

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

[@sagarananthashayana8513]

How to forward an email to specific email recipients with attachment

[@sarunas44]

Thanks!

[@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 ?

[@kaibalyasahoo6634]

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

[@zubarmalik4672]

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

[@Tat-cx1lr]

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

[@noeadrias4586]

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

[@noelledillenburg6116]

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?

[@Tat-cx1lr]

Super merci

[@lindacharlton-gunderson5690]

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?

[@monicatompkins3295]

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.

[@christfollower122491]

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

[@KnackTraining]

You need to create multiple macros (each macro must have a unique name), each of which call to a different file name.

[@veronikadvorsak1223]

@@KnackTraining Sorry, but where can I add the new macro?

[@lindacharlton-gunderson8959]

Where can I find the code that you in this video? This exactly what I was looking for

[@JibbsCompilations]

Check the link in his description, the code is there!

[@ManuelSilva-dl9oq]

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."

[@Dutlerveili]

Same problem here... I was looking for a solution for hours but I could not figure out, how I to fix it :( I would LOVE to use macros to reply to Emails, could PLEASE anyone help us? :(

[@stefankragulj8199]

Within Visual basic go to tools-reference and make sure that Microsoft Outlook library is ticked (enabled)

[@lyndabarry4813]

Hi at 2min 58 you paste file path into “notepad file”… what’s that bit, where’s notepad file? Thanks

[@lindacharlton-gunderson8959]

Did you find the notepad codes?

[@julianchan692]

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 "C:\Users\Administrator\AppData\Roaming\Microsoft\Templates\dhlecommerce.oft"

[@KnackTraining]

Recently an Adobe plug-in has broken this - if you deactivate that plug-in, it works again. Another option is that your macros might be disabled.

[@erikb8838]

@@KnackTraining My button worked once and then it stopped working. Any idea why?

[@paulinamunoz6354]

same happened to me and I already enable all macros, I see the button but is not working. Did you find a solution by any chance?

[@melissaaguirre3193]

Hello! Thank you for the macro! I’m having an issue with the pictures on my signature- for some reason they don’t display correctly. Could you help me? Everything else works great

[@comptondnb7931]

Did you find a fix?

[@Jenn-cf2uy]

I'm deleting my signature on the template, but it is showing on my auto reply, then again at the very bottom after the original email. How do I change it to only show after my reply?

[@comptondnb7931]

Did you find a fix?

[@rajvenkat3641]

What is the procedure if wants to display 2 or 3 email templates to display at once ?? Calling 2 or 3 emails template at once ...pls suggest

[@KnackTraining]

You'll need multiple copies of the macro - give each a unique name, and have each pull a different template!

[@rajvenkat3641]

@@KnackTraining can you help with example script to call templates at same time..

[@joaquin5292]

Bro it didn't work...