PDA

View Full Version : VBA Code to Find & Remove certain text from email body



Mahesh Babu
2012-11-18, 04:48 AM
Hi All,

I want to find certain text and remove from the body of the mail. Can you help out in providing a macro(VBA Code) to delete specific text from the email body.

For example my body of the mail is as below:


I am contacting you regarding the missing information/documents of this client. Request you to provide the same.


Job ID 13353
:- 1178838
Client/Information/Year : IBM Laptop Manual for the year 2011
: Microsoft Processor Version for the year 2012
Comments Need Original 2 Copies

Request ABC bank to reply with the missing information ASAP. If not, leads to decrease in the production charges.
-----------------------------------


For every email the above highlighted text in BOLD is common. But i don't want that information. I want a macro to delete the highlighted text.

Ken Puls
2012-11-30, 06:15 AM
Mahesh,

Is this related to the work we have been working on in this thread (http://www.excelguru.ca/forums/showthread.php?1222-Copy-from-excel-and-paste-in-outlook)? If it is, why don't we just adjust the macro so that it doesn't pull in that info?