How to email just a sheet or a selected area of the sheet

J

jennie

Hi,

I wish to email just a single sheet, or even better a selected
specified area of that single sheet, automatically when the use
presses a button, instead of the whole workbook which contains a lot o
data and macros.

Does anyone know how I can do this?

Please let me know if you have any suggestions
Thanks a lot
Jenni
 
I

icestationzbra

peo sjoblom (an excel MVP and one of the pillars of this forum) has som
outlook addins where in this can be done. i am not able to find th
link right now, i will get back to this thread if i am able to
 
I

icestationzbra

oops, i am very sorry, that was ron de bruin. just slipped my mind, n
offence meant. another poster has provided the right link, m
apologies
 
J

jennie

Hi again,

Thanks for the link, however I can not use an add in as it will be use
by lots of different people who will not have the add in, also the mai
handler is Lotus Notes not Outlook.

Any help would be great
Thanks
Jenni
 
R

Rollin_Again

I think you should be able to add *MAPISession* and *MAPIMessages
controls to your workbook and then add some simple VBA code t
accomplish what you want. I haven't tried using it with Lotus Note
but I think it should work. I've got the code if you want it.



Rolli
 
R

Rollin_Again

Does anyone know if the workbooks *.SendMail* method only work with
Outlook and Outlook Express? I've never used any other mail clients
other than Outlook and Outlook Express.

Rollin
 
R

Ron de Bruin

Hi jennie

Maybe CDO is a option for you
http://www.rondebruin.nl/cdo.htm

Or be sure your users also have a Account in Outlook Express
And make this mail program your Office mail program

For all your other stuff you can use Lotus Notes
 
R

Ron de Bruin

Hi icestationzbra

No problem that you use Peo's name instead of mine.
It is a compliment <g>
 
I

icestationzbra

:), since every one is in such a hunky dory mutual admiration mode, i
might as well throw caution to the winds and start muddling up names.
that seems to get me replies from the big 'uns, you see :-D...

mac.
 
Top