[b]Send Worksheet to Mail Recipient [/b]

[trystanhuwwilliams1]

Good Morning,

I have a button on a worksheet which sends the worksheet
to a Mail Recipient as below:

CommandBars("Send To").Controls("Mail Recipient").Execute

There are 50 users who have this facility (to email their timesheet) and for most people this works fine. However it doesn't work for all despite the fact that everyone has Outlook & Excel 2000.

Does anyone know of any option preference, Addin or known problems which might be the cause?

Thank you very much,


T

 

[xlbo]

How does it not work ?? does it just not send or is there an error message generated ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question