troubleshooting Question

VBA to Forward an email from Inbox.

Avatar of RWayneH
RWayneHFlag for United States of America asked on
OutlookVBA
7 Comments1 Solution113 ViewsLast Modified:
Is it possible to preform the following steps on an Outlook email in VBA?  After filtering the InBox, I need to perform this on a bunch of emails.

1. Copy current existing email Subject:
2. Click Forward
3. Delete the top portion, in the body of the email, up to and including the line that has Subject: (this would be the old Subject, prior to Forward click in Step 1)
4. Remove FW: from the new Subject field, (or use Subject from Step 1)
5. Find the first email address in the body of the email and replace what is in the To: field with that.
6. In the body of the email there is the following:  Partner Number: 23611  I need to harvest the number after it.  23611  (some or 5 digits others are 6 could be a 7)

Looking for some guidance, on writing this Sub in OutLook VBA.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros