how can i send email with attachments paths (3 workbooks) located in the cell a1 to a3
I have three file paths a1, a2, a3. How can i send an emai that would
open those files in a1,a2 and a3 cells and send mail with an attachment
of those three files.
hope i am making it clear
the cells look like this: for example:
\\sbwap\pnlreports\daily\pnlreportcard_060322.xls
\\sbwap\pnlreports\daily\pnlreportcardbasic_060322 .xls
\\sbwap\pnlreports\format.xls
i need to send these three files on daily basis as attachment in mail.
the server is microsoft exchange server
please help.
|