Hi Rob,
You may want to look how to do this from within Word. Maybe this would give you an idea to start?
How to send an email from Word using VBA
http://www.mvps.org/word/FAQs/InterDev/SendMail.htm
Hope this helps,
regards,
Astrid
So that all can benefit from the discussion, please post all follow-ups to the newsgroup.
Visit the MVP Word FAQ site at http://www.mvps.org/word/
Quote:
> Does anyone know how I can get a VBA procedure to e-mail a sheet to an
> address that my procedure specifys?
E-mail an excel sheet