email worksheet from Excel 2003 using Outlook 2007

[Csabi]

I have just installed Outlook 2007 and have noticed that I can no longer
email a worksheet from Excel 2003 - prior to installing Outlook 2007 I had an
icon "amil recipient" next to the "save" icon which would embed the worksheet
in an email and send - can you please advise how I can set this up using
Outlook 2007 - Thanks

 

[Csabi]

Sorry Meant "Mail Recipient"

 

[Ron de Bruin]

You can add this option to the QAT and close it

See how here
http://www.rondebruin.nl/0307commands.htm

The name = "Send to Mail Recepient"

 

[Ron de Bruin]

Sorry you only use Outlook 2007

See this page
http://www.rondebruin.nl/mail/problems.htm

 

[Csabi]

I purchased Publisher 2007 which requires Outlook 2007 for emailing - the
other programs excel, word etc I am using from office 2003

 

[Ron de Bruin]

Read the info in the link I posted

 

[Csabi]

Thanks Ron, just to clarify - when I was using outlook 2003 with excel 2003
then all I had to do to email a page was to click on an icon "mail recipient"
- now to do the same thin using excel 2003 with outlook 2007 I have to set up
a macro - is this correct?

 

[Csabi]

Hi Ron, I will try the send mail addin and see how I go - Many thanks

 

[Ron de Bruin]

a macro - is this correct?

Yes if you want to send a sheet in the body mail this is the only way as far as I know
if your Outlook version is not the same as your Excel version

 

[Csabi]

Hi Ron, I have used sendmail and works well although I did like the
"mailrecipient" icon would imbed the sheet into the email and not as an
attachment - thank you very much for your help

 

[Ron de Bruin]

If you use the Outlook add-in there is a body option

For code see
http://www.rondebruin.nl/mail/folder3/mail2.htm

Or

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

 

[Csabi]

Hi Ron,

This code does what I wanted - with a bit of tweeking I think I will get the
same funtionality I had previously - Thanks heaps