running macro and sending email

P

Pam Coleman

I have 2 macros created which exports an excel spreadsheet to our server, is
there a way to run the macro and then send it through Outlook without having
to attach the spreadsheet? It will be sent to several and this will be done
everyday.

Thanks,
 
S

Steve Schapel

Pam,

I'm sorry, I don't quite understand what you mean. Send an email to
"several" without the spreadsheet attached, so they will know to look on
the server for the file? Can you give an example of what you want to
happen?
 
Top