Archive of Mr Excel Message Board

Back to Excel VBA archive index
Back to archive home

How to email excel spread sheet using macro?

Posted by Fatou N'Jie on April 18, 2000 7:14 AM

Please help! I have written an excel macro that opens a text file, formats the file, prints the file and saves it to a directory. In addition, I would like to include some code that will automatically distribute the file to various people through an email. Does anyone know how to do this? Please reply ASAP. Thank you.

Check out our Excel VBA Resources

Re: How to email excel spread sheet using macro?

Posted by JAF on April 18, 2000 7:43 AM

http://www.j-walk.com/ss/excel/tips/tip86.htm should point you in the right direction.

Thank you! Re: How to email excel spread sheet using macro?

Posted by Fatou N'Jie on April 21, 2000 12:01 PM

Thank you!

I appreciate the info you sent me. However, do you know some code that can be included in the existing code to attach a report and send it to users in the contact list in Outlook 98. I use windows nt. Thank you.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.