ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   email a worksheet (https://www.excelbanter.com/excel-programming/330397-email-worksheet.html)

choice[_2_]

email a worksheet
 
i need to email the contents of a sheet in the body of a email.
if i have data from A1:Z20, but i only want the data from A1:C20 to be in
the body of the email, how would i NOT include D1:Z20.
Also, if there is a JPEG Inserted in the sheet, could that be inserted in
the body of the email?

thanks in advance

Ron de Bruin

email a worksheet
 
Hi choice

See
http://www.rondebruin.nl/mail/folder3/mail4.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"choice" wrote in message ...
i need to email the contents of a sheet in the body of a email.
if i have data from A1:Z20, but i only want the data from A1:C20 to be in
the body of the email, how would i NOT include D1:Z20.
Also, if there is a JPEG Inserted in the sheet, could that be inserted in
the body of the email?

thanks in advance




choice[_2_]

email a worksheet
 
will this work for Outlook Express?
and
Will it email an inserted jpeg that is in that range?

"Ron de Bruin" wrote:

Hi choice

See
http://www.rondebruin.nl/mail/folder3/mail4.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"choice" wrote in message ...
i need to email the contents of a sheet in the body of a email.
if i have data from A1:Z20, but i only want the data from A1:C20 to be in
the body of the email, how would i NOT include D1:Z20.
Also, if there is a JPEG Inserted in the sheet, could that be inserted in
the body of the email?

thanks in advance





Ron de Bruin

email a worksheet
 
will this work for Outlook Express?
No but you can use CDO then
http://www.rondebruin.nl/cdo.htm

and
Will it email an inserted jpeg that is in that range?

Only if you run Outlook 2002-2003
See the link om my page

--
Regards Ron de Bruin
http://www.rondebruin.nl



"choice" wrote in message ...
will this work for Outlook Express?
and
Will it email an inserted jpeg that is in that range?

"Ron de Bruin" wrote:

Hi choice

See
http://www.rondebruin.nl/mail/folder3/mail4.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"choice" wrote in message ...
i need to email the contents of a sheet in the body of a email.
if i have data from A1:Z20, but i only want the data from A1:C20 to be in
the body of the email, how would i NOT include D1:Z20.
Also, if there is a JPEG Inserted in the sheet, could that be inserted in
the body of the email?

thanks in advance








All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com