send a worksheet and allow user to choose recipient... 1

[danomaniac]

I have a worksheet that is emailed by many to many daily. Many people still send it as an attachment rather than just the sheet. I've instructed till I'm blue in the face. I want a button that invokes the 'send to' command and allows the user to choose the recipient from their address book prior to clicking 'send this sheet'. Thanks for any help


"It's more like it is now, than it ever has been."

 

[xlbo]

summat like this:

ThisWorkbook.SendMail "", "Subject"

??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[danomaniac]

Thanks Geoff,
I tried that, but it sends it as an attachment..I want it embedded in the email.

"It's more like it is now, than it ever has been."

 

[xlbo]

Unfortunately (in xl2003) you cannot automate that. You would need to automate Outlook and paste the sheet in as an embedded OLE object...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[xlbo]

apologies - you can of course do it but the only way I can think of is with SENDKEYS (which is best avoided most of the time)

Sub SendSheet()
SendKeys "%FDM"
End sub

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[johnny45]

Take a peek here for more info:

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