running macro and sending email

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pam Coleman - 25 May 2005 16:31 GMT

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,

Reply to this Message

Steve Schapel - 25 May 2005 19:38 GMT

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?

Signature

Steve Schapel, Microsoft Access MVP

> 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,

Reply to this Message