Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Outlook - Extract values from email body and remove lines
With the code you gave me to extract the email addresses from the body I have a problem: it works with your code, but the problem is that I can't get the same format from the real emails. For example, if I get the text from the email body using MailItem.Body and parse it with your code I get...- HuanManwe
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Outlook - Extract values from email body and remove lines
Thank you for your reply. This code looks nice but I have a problem: 1.- The emails within the email body are always different, and sometimes they're from 2 email addresses to about 10 email addresses. 2.- As the content of the email is always a bit different I can't use "Dim strBody As...- HuanManwe
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Outlook - Extract values from email body and remove lines
CONFIRMATION MAIL whatever@something.com; etwas@deutsch.com; algo@hispano.es About the analysis given: Good Morning Could you please confirm these analysis? I'm trying several things at the same time so maybe my code is messy and duplicated. Thanks for your help. Sub AA7() Dim Tbl As...- HuanManwe
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Outlook - Extract values from email body and remove lines
Hi all, I need to create a macro to reply to Outlook mails with the same emails received but changing a few things: 1.- I need to extract the .To information from the email body. At the moment I only get ONE email address: Code: If InStr(1, vText(i), "@") Then sText = Replace(vText(i)...- HuanManwe
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
