mailbharath
New Member
- Joined
- Feb 10, 2011
- Messages
- 10
I have 2 macros and they do the below functions.
1 ) picks up certain fields from sheet in excel and puts in an email and shoots an email using Outlook.
2 ) picks up certain fields from sheet1 in excel puts it in sheet 2 and saves sheet 2 as a new file, then attaches it to an email in outlook and sends it.
However, what I need is as below.
I want is to combine it. As in I want certain fields to be picked up from sheet 1 to be inserted in sheet to at the respective places. Copy the entire sheet2 paste it as HTML in a new email in outlook and then pick email address for the respective client and sent it.
Would also like to know if I use the first method is there a way i can exceed 25 lines of text to be there in an email? and use some .jpg files to be displayed in an email.
1 ) picks up certain fields from sheet in excel and puts in an email and shoots an email using Outlook.
2 ) picks up certain fields from sheet1 in excel puts it in sheet 2 and saves sheet 2 as a new file, then attaches it to an email in outlook and sends it.
However, what I need is as below.
I want is to combine it. As in I want certain fields to be picked up from sheet 1 to be inserted in sheet to at the respective places. Copy the entire sheet2 paste it as HTML in a new email in outlook and then pick email address for the respective client and sent it.
Would also like to know if I use the first method is there a way i can exceed 25 lines of text to be there in an email? and use some .jpg files to be displayed in an email.