outlook vba

chouston · May 2nd, 2002, 05:43 PM

I saw someone else post an outlook question so I guess I'll cheat too. I need to send my spreadsheet to several clients (65) so they can use view it and use the macros built in. Where is a good source of information for how to use outlook to automatically save this spreadsheet to their hardrive?

Thanks in advance for any replies!

Mark O'Brien · May 2nd, 2002, 06:14 PM

It's not cheating, you don't need VBA in Outlook to accomplish this.

Have a search on this site for the "SendMail" in Excel VBA help and on this board. You may find some good references and some good advice on what you want to accomplish on this site.

HTH

May 2nd, 2002, 06:14 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	It's not cheating, you don't need VBA in Outlook to accomplish this. Have a search on this site for the "SendMail" in Excel VBA help and on this board. You may find some good references and some good advice on what you want to accomplish on this site. HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 05:43 PM	#1
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	I saw someone else post an outlook question so I guess I'll cheat too. I need to send my spreadsheet to several clients (65) so they can use view it and use the macros built in. Where is a good source of information for how to use outlook to automatically save this spreadsheet to their hardrive? Thanks in advance for any replies!