PeggieGreg
asked on
Automatic Email Send / extract email from body
Hi Experts,
I have asked similar questions before but I never seem to get an answer which tells me exactly what I need to do.
we get emails come through from other companies which have leads for potential customers. these potential customer leads are also given to other companies like ours and therefore we need to react as quickly as possible to them.
I am looking for a solution that will take this email lead, extract the email address from the email body and then send an automatic email to that potential customer asking them to contact our company.
so I tried doing this before by extracting the emails into a excel spread sheet from the email body and trying to use mail merge to send them but with very little experience with mail merge I weren't even able to say if what I wanted to do was possible. With regards to the emails address being extracted into excel, this was a macro that is run from outlook and I got the macro script online.
please find below the details of the environment I am working within
office 2003 (outlook 2003, word 2003, excel 2003)
SBS2011
Windows 7
so I guess I am looking for someone to either tell me that this is not the best way to do it and can suggest the best way to do it or if someone can inform me how to use the method I am already trying to use properly.
look forward to hearing from the Experts.
Peggiegreg
I have asked similar questions before but I never seem to get an answer which tells me exactly what I need to do.
we get emails come through from other companies which have leads for potential customers. these potential customer leads are also given to other companies like ours and therefore we need to react as quickly as possible to them.
I am looking for a solution that will take this email lead, extract the email address from the email body and then send an automatic email to that potential customer asking them to contact our company.
so I tried doing this before by extracting the emails into a excel spread sheet from the email body and trying to use mail merge to send them but with very little experience with mail merge I weren't even able to say if what I wanted to do was possible. With regards to the emails address being extracted into excel, this was a macro that is run from outlook and I got the macro script online.
please find below the details of the environment I am working within
office 2003 (outlook 2003, word 2003, excel 2003)
SBS2011
Windows 7
so I guess I am looking for someone to either tell me that this is not the best way to do it and can suggest the best way to do it or if someone can inform me how to use the method I am already trying to use properly.
look forward to hearing from the Experts.
Peggiegreg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no this does not answer my questions professorjimjam. this answers how to extract to an excel spreadsheet but I need to know how to complete the entire process. this includes sending the emails and if I am doing it in the best way.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am trying to do this at the moment regmigrant and I will update ASAP with my results. thanks for your reply
ASKER
this looks like it will work fine, I just haven't got the time to test fully atm. I will post in the future when I can try this fully.
thanks anyway!
thanks anyway!
i have answered to similar questions in the past, i can say that extracting only email addresses from the body of outlook is not faily easy code, here is the workaround a macro that extracts the email address from outlook and lists them to Excel.
please see my detailed answer in the link below.
https://www.experts-exchange.com/questions/28711354/Parse-an-email-folder-Outlook-2010-that-contains-undelivered-or-returned-email-errors.html?searchNotTop10=true