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

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

for sending the current sheet

--
Regards
Frank Kabel
Frankfurt, Germany

"ZABU" schrieb im Newsbeitrag
...
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

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.

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
""Peter Huang"" wrote in message
...
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.