ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   email worksheet from Excel 2003 using Outlook 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/172422-email-worksheet-excel-2003-using-outlook-2007-a.html)

Csabi

email worksheet from Excel 2003 using Outlook 2007
 
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

email worksheet from Excel 2003 using Outlook 2007
 
Sorry Meant "Mail Recipient"

"Csabi" wrote:

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


Ron de Bruin

email worksheet from Excel 2003 using Outlook 2007
 
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"


--

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


"Csabi" wrote in message ...
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


Ron de Bruin

email worksheet from Excel 2003 using Outlook 2007
 
Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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

email worksheet from Excel 2003 using Outlook 2007
 
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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



Ron de Bruin

email worksheet from Excel 2003 using Outlook 2007
 
Read the info in the link I posted

--

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


"Csabi" wrote in message ...
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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

email worksheet from Excel 2003 using Outlook 2007
 
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?

"Ron de Bruin" wrote:

Read the info in the link I posted

--

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


"Csabi" wrote in message ...
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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

email worksheet from Excel 2003 using Outlook 2007
 
Hi Ron, I will try the send mail addin and see how I go - Many thanks

"Ron de Bruin" wrote:

Read the info in the link I posted

--

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


"Csabi" wrote in message ...
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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



Ron de Bruin

email worksheet from Excel 2003 using Outlook 2007
 
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

--

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


"Csabi" wrote in message ...
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?

"Ron de Bruin" wrote:

Read the info in the link I posted

--

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


"Csabi" wrote in message ...
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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

email worksheet from Excel 2003 using Outlook 2007
 
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" wrote:

Read the info in the link I posted

--

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


"Csabi" wrote in message ...
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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



Ron de Bruin

email worksheet from Excel 2003 using Outlook 2007
 
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

--

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


"Csabi" wrote in message ...
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" wrote:

Read the info in the link I posted

--

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


"Csabi" wrote in message ...
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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

email worksheet from Excel 2003 using Outlook 2007
 
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

"Ron de Bruin" wrote:

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

--

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


"Csabi" wrote in message ...
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" wrote:

Read the info in the link I posted

--

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


"Csabi" wrote in message ...
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" wrote:

Sorry you only use Outlook 2007

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


--

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


"Ron de Bruin" wrote in message ...
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"


--

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


"Csabi" wrote in message ...
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





All times are GMT +1. The time now is 12:08 AM.

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