Sending Workbook By Email

[Ben Allen]

Hi,
I'm new to VBA and would like to send my workbook via email using a VBA
Userform from within that workbook.
Many thanks for any advice,
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/sendmail.htm
for many (IMHO excellent) code examples

 

[Ben Allen]

Hi
have a look at
http://www.rondebruin.nl/sendmail.htm
for many (IMHO excellent) code examples

Cheers Frank, I'd been on there before after searching the forms but for
some reason the code to send the workbook would not work for me, i kept
getting 'Error 75' after the code had been run once. I now have the
'multiple sheets' code working, is there an array that selects ALL sheets
or another function i can put in its place?

Thanks Again,
Ben

 

[Ron de Bruin]

Hi Ben

If you send me your workbook(private)
I take a look at it for you

 

[Bob Smith]

Hi,
I'm new to VBA and would like to send my workbook via email using a VBA
Userform from within that workbook.
Many thanks for any advice,

Hmmm, what's wrong with sending it via File - Send To and send it as an
attachment?

Bob

 

[Ron de Bruin]

You hear from me tomorrow Ben

 

[Ron de Bruin]

Hi Ben

I think you are running Excel 2000 (Sp1)
This problem is fixed in sp2

http://support.microsoft.com/default.aspx?scid=kb;en-us;264712

You are not happy with this I think because you get the security message
from Outlook if you update

The workeround is to add the buttons on your sheet instead of the userform

 

[Ben Allen]

Hmmm, what's wrong with sending it via File - Send To and send it as
an attachment?

Bob

I need it to have the email address already specified, thanks anyway.
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"

 

[Ben Allen]

Hi Ben

I think you are running Excel 2000 (Sp1)
This problem is fixed in sp2

http://support.microsoft.com/default.aspx?scid=kb;en-us;264712

You are not happy with this I think because you get the security
message
from Outlook if you update

The workeround is to add the buttons on your sheet instead of the
userform

Ok thanks for all your help Ron, i am downloading the service pack now, so
it should work soon. Excel 2000 is just the version i am building it on, the
pcs on which it which it will actaually be run use XP so it should be ok in
that, just useful to be able to test it though.
Again, thanks for all your help.
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"