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