Send current Excel File as an attachment using Outlook 2000

[ZABU]

I am updating a file and would like the file to be mailed to a distribution
list as an attachment. I have found some code that will copy a selected
range into a new workbook and then mail to the distribution list. However,
this method appears to have a limitation of 256 character per cell limit.
The users of this form sometimes exceed the character limit and some
information is not included in the workbook that was mailed. Any ideas?
Using Outlook 2000 and Excel 2000 on Windows 2000.

Regards,

ZABU

 

[Frank Kabel]

Hi
see:
http://www.rondebruin.nl/sendmail.htm

for sending the current sheet

 

[Peter Huang]

Hi ZABU,

Did Frank's suggestion help you?
If you still have any concern, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[ZABU]

I am currently evaluating the types of mailing options sent by Frank. I
will reply with the results some time next week. Thank you for you inquery.

Regards,

ZABU