PDA

View Full Version : Send Excel Body by Outlook



balkrishna
10-16-2012, 10:07 PM
Hi,
I have a excel sheet in which Sheet1 have some data. I want all the data will be filtered and create separate sheets based on column A. And all the sheets will be converted with separate files and will save in D drive folder named MyFolder. In each saved file I need to save after delete the second row which is related to the self employee name (Example sheet attached). I have a sheet named Master Data in which I have saved all the employees record. In Mail Data Sheet i have updated A, B, C & F column by vlookup of Master Data Sheet. Now I want to send email via Outlook to all the recipients of C column based on D column. Means mail will send to them only when D column have mentioned yes. After sending mails in E column will mention send. By which it will confirm that the mail was send to that person only. And in that mail I need only some messages and body of the excel sheet. Not the whole excel file. Below I have mentioned what I exactly want. Please help me to solve my query.