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

  • Thread starter Thread starter VB Script for Excel
  • Start date Start date
V

VB Script for Excel

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to code it in macro? 2
How to work with reference unions (A1,A3,A5)? 4
How do Excel display Cell values and stores internally? 5
Send e-mail via macro 1
I need a formula for if cells a1 and a2 are the same then cell a3 3
Building closed workbook file path within an Index Function 6
How can I make a cell to flash? 6
How to reference a cell from anther workbook without opening it 0

Back
Top