sending email with selected columns frm excel
Hi,
in my xl sheet i have 8 columns. in the 8th column of each row I have a check box. Now as soon as I click on the check box I want the 1st, 2nd and 5th column data of the corresponding row to be send through email. the email address is supplied by me through a file. I also want to supply the heading for the column names in the email.
Please help me. I previously tried a macro that created a HTML file in background and then sent it to the email ID. but this create a popup dialog in which the MS Outlook ask "yes", "no", etc. I dont want this confirmation to be shown to me. Coz emailing the data is a must.
bye,
Kaustav
__________________
------------------
Kaustav
|