Outlook VBA Macro to extract email address from Message Body
- or -
Post a project like this3479
£10/hr(approx. $13/hr)
- Posted:
- Proposals: 2
- Remote
- #574144
- Completed
Description
Experience Level: Entry
Estimated project duration: 1 day or less
General information for the business: Email Marketing
Kind of development: New program from scratch
Description of requirements/functionality: I need a Outlook VBA Macro that will allow me to select a folder then run the macro. It would cycle through all emails in that mail box (no sub folders), and extract the first email address it came to in the content. It would then output these to a CSV file.
We are getting a lot of rejected email messages from small marketing campaigns we run where the domain is no longer valid, so we want to get a list of these and remove them from our list.
Therefore, normally in these bounce emails, it is not from the person, but the first email address in the content is normally the one we want. To make it a little harder, these are sometimes enclosed in signs which need to be removed.
I would normally have a stab at doing this myself, but I just don’t have the time, as VBA within Outlook isn’t my forte, although I am good with VBA generally.
If I were doing it, I would loop through the emails, find the first @ sign, work backwards from the sign checking for valid email characters to set the start point, then forward checking for valid characters to find the end point. Save to file.
I am sure there are other ways, but I will leave this up to you. For a good VBA programmer, I doubt this would take more than an hour.
Thanks. Any questions, do ask. I do need this pretty quick, so early proposers are likely to get the job.
OS requirements: Windows
Extra notes:
Kind of development: New program from scratch
Description of requirements/functionality: I need a Outlook VBA Macro that will allow me to select a folder then run the macro. It would cycle through all emails in that mail box (no sub folders), and extract the first email address it came to in the content. It would then output these to a CSV file.
We are getting a lot of rejected email messages from small marketing campaigns we run where the domain is no longer valid, so we want to get a list of these and remove them from our list.
Therefore, normally in these bounce emails, it is not from the person, but the first email address in the content is normally the one we want. To make it a little harder, these are sometimes enclosed in signs which need to be removed.
I would normally have a stab at doing this myself, but I just don’t have the time, as VBA within Outlook isn’t my forte, although I am good with VBA generally.
If I were doing it, I would loop through the emails, find the first @ sign, work backwards from the sign checking for valid email characters to set the start point, then forward checking for valid characters to find the end point. Save to file.
I am sure there are other ways, but I will leave this up to you. For a good VBA programmer, I doubt this would take more than an hour.
Thanks. Any questions, do ask. I do need this pretty quick, so early proposers are likely to get the job.
OS requirements: Windows
Extra notes:
Richard C.
100% (6)Projects Completed
10
Freelancers worked with
10
Projects awarded
46%
Last project
18 Sep 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies