Dear Ron (I beg your pardon DJL!!),
If I may, is there a way of inserting more than 2 lines (a long text) in the
body of an e-mail?
i.e.
"Dear xyz,
Please find attached blah, blah, blah, blah, blah, .......
This attachment gives detailed information on blah, blah, blah, blah, blah,
.......
Should you have any question blah, blah, blah, blah, blah,
Best regards,
x2dmp"

Prabha

"Ron de Bruin" wrote:

Hi DJL

Do you have the same problem if you change number 4 on this page
http://www.rondebruin.nl/mail/problems.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"DJL" wrote in message ...
I have written a macro for Excel that distributes the active workbook to
predefined Outlook recipients. It works fine as I step through it in the
debugger. Excel quits responding when the macro is executed from from the
spreadsheet. I suspect it is getting hung up on the prompt from Outlook
requesting permission to send email on user's behalf. How can I fix this
without defeating security features?

Windows XP sp1
Visual Basic 6.3
Excel 2003 SP1
Outlook 2003