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.

how can i send email with attachments paths (3 workbooks) located in the cell a1 to a3
 

hi

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

regards Yngve