E-mail Macro

  • Thread starter Thread starter STEVEB
  • Start date Start date
S

STEVEB

Hi All,

I have an E-mail macro that currently sends an attachemnt to anyon
listed in sheet 1 column A. The attachement is .attacments.ad
"C:\XXX.Xls". Everything works Fine. However, I was wondering if ther
was a way to have the Macro send whatever attachment is listed in shee
2 column A rather than having to list the attachments in the macro cod
as .attachments.add.

Any help would be greatly appreciated
 
Just replace the filename with Worksheets("Sheet2").Range("B1").Value
 
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

Mail a different file(s) to each person in a range 0
Excel Macros sending attachments to multiple e-mail addressescontained in one cell. 4
Attach file to e-mail using excel macro 2
Attach Files Listed in Columns with Email 7
Macro buttons 2
Macro to use information in a cell to locate and send files using outlook 0
Modifying an Excel 2000 Macro 4
select and e-mail multiple attachments via Outlook 13

Back
Top