ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Emailing Spreadsheet as a body (https://www.excelbanter.com/excel-programming/416470-emailing-spreadsheet-body.html)

NateBuckley

Emailing Spreadsheet as a body
 
Hello, I'm just wondering if its possible VBA wise to send a spreadsheet (a
particular sheet) in an email within the body, rather than a file.

Cheers for any advice.

Mike H

Emailing Spreadsheet as a body
 
Hi,

You should find an answer here

http://www.rondebruin.nl/mail/folder1/mail2.htm

Mike

"NateBuckley" wrote:

Hello, I'm just wondering if its possible VBA wise to send a spreadsheet (a
particular sheet) in an email within the body, rather than a file.

Cheers for any advice.


NateBuckley

Emailing Spreadsheet as a body
 
Cheers, That's what I was looking for, was using the .SendMail functin and on
that page it says that its not possible to send as a body with that function,
so saved me a lot of tedious failing.

Thanks matey!

"Mike H" wrote:

Hi,

You should find an answer here

http://www.rondebruin.nl/mail/folder1/mail2.htm

Mike

"NateBuckley" wrote:

Hello, I'm just wondering if its possible VBA wise to send a spreadsheet (a
particular sheet) in an email within the body, rather than a file.

Cheers for any advice.


Ron de Bruin

Emailing Spreadsheet as a body
 
Have you see the other examples that can do what you want ?

See
http://www.rondebruin.nl/sendmail.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"NateBuckley" wrote in message ...
Cheers, That's what I was looking for, was using the .SendMail functin and on
that page it says that its not possible to send as a body with that function,
so saved me a lot of tedious failing.

Thanks matey!

"Mike H" wrote:

Hi,

You should find an answer here

http://www.rondebruin.nl/mail/folder1/mail2.htm

Mike

"NateBuckley" wrote:

Hello, I'm just wondering if its possible VBA wise to send a spreadsheet (a
particular sheet) in an email within the body, rather than a file.

Cheers for any advice.



All times are GMT +1. The time now is 01:57 AM.

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