how can i send an email using Excel VBA and Outlook. but i need the excel in the body of the email.
- Thread starter Jenn1981
- Start date
Check out some of Ron's codes here:
http://www.rondebruin.nl/win/s1/outlook/mail.htm
One of these should match what you want.
http://www.rondebruin.nl/win/s1/outlook/mail.htm
One of these should match what you want.
Hi @Luke M ,
I read the reference but my situation is a bit different. Here in the excel file attached below I want to send the email to the person who are at the column Q. The criteria is the data should be sent via outlook and the header should be sent along with the data. in the excel file attached I have highlighted the cells to show how the data should be sent .But the data with today's date should only be sent. for eg: if the date today is 25-mar only the data of that particular date should be sent.
Below excel sheet shows the highlighted cells. now another point is if we are sending to the same person(here in this eg. a@yahoo.com) for different POs the excel should club the data together and send it. And if the data is sent once for that particular date then if we add more data later on that date it should only sent the data which are not sent.
How can i do it with the macros
I read the reference but my situation is a bit different. Here in the excel file attached below I want to send the email to the person who are at the column Q. The criteria is the data should be sent via outlook and the header should be sent along with the data. in the excel file attached I have highlighted the cells to show how the data should be sent .But the data with today's date should only be sent. for eg: if the date today is 25-mar only the data of that particular date should be sent.
Below excel sheet shows the highlighted cells. now another point is if we are sending to the same person(here in this eg. a@yahoo.com) for different POs the excel should club the data together and send it. And if the data is sent once for that particular date then if we add more data later on that date it should only sent the data which are not sent.
How can i do it with the macros