Reply to Email through Excel VBA

**aaron.mendes** · 05-23-2014, 11:16 AM

Hi,

I have a code to create new emails and send through VBA. PLease see below.
However, I am new to VBA and have searched everywhere for a code that would help in replying to emails through VBA.
I have many emails and my reply is more or less standard. Is there a code, where i can 1) select the email that i want to reply, 2) pick up the body of the email from my excel file (designated Range/cell) and 3) send out the email to the recipient?

Your help would be much appreciated.

Please Login or Register  to view this content.

**Tinbendr** · 05-23-2014, 06:09 PM

And how does this code not work for you?

**aaron.mendes** · 05-26-2014, 04:34 AM

Hi David - this code is for composing new emails. And what i am looking for is a reply to emails that hits my inbox.

**Tinbendr** · 05-26-2014, 07:36 AM

So, let me see if I understand. When you get an email, you want to reply with a certain fixed reply based on the one who sent it?

I do something similar. I have to send in a 'request'. This request is the always the same, except for PO# and a couple of phrases.

As far as your request 1), 2), & 3), those are all possible. I recommend writing this in Outlook, and getting the data from Excel.

I am also going to recommend that you repost this in the Outlook forum and post a link back to this message. I am not that well versed in Outlook and a solution from me might take a long time.

**aaron.mendes** · 05-26-2014, 07:52 AM

Yes, you guessed it right. However, I will post this in the outlook forum. Thanks for your help.

Reply to Email through Excel VBA

LinkBack

Thread Tools

Rate This Thread

Display

Reply to Email through Excel VBA

Re: Reply to Email through Excel VBA

Re: Reply to Email through Excel VBA

Re: Reply to Email through Excel VBA

Re: Reply to Email through Excel VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Search Email And Add Reply To It

[SOLVED] Reply ALL email from excel Range will not CC or Bcc original recipients

Using Excel VBA Macro to Reply to email in Outlook

[SOLVED] Reply to outlook email from excel script

control outlook to reply to email

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions