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

  • Thread starter Thread starter jennie
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
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
 
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
 
Hi icestationzbra

No problem that you use Peo's name instead of mine.
It is a compliment <g>
 
:-), 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

e-mailing a single Sheet 1
how do I attach just one single sheet to an email in Excel 2007 1
MATCHING A VALUE IN A CELL TO A COLUMN OF VALUES IN ANOTHER SHEET 1
How do I set a print area for every sheet in the workbook? 2
HELP - A formula or sheet you want to move or copy contains the name .... 0
Selecting active area of sheet 4
Copying parts of a sheet with macro 7
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10

Back
Top