View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default Emailing an Excel File with a Macro through Outlook

Tyson,

Try Ron de Bruin's site for code examples (and an Add-In that
might automate the process for you)

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

John

Tysone wrote:

What I'm trying to do is write something in VB that will allow me to
send an excel file as an attachment through Outlook.

My Email Address will always be in D5 and my Subject will always be in
C3.

I have searched a bunch of news groups, but I can't find something
that I can adapt to my needs.

I'm not much of a programmer, but I can cut and paste with the best of
them. Any help would be awesome.

Thanks for your time,

Tyson