View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VB Script for Excel VB Script for Excel is offline
external usenet poster
 
Posts: 19
Default 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.