Thread: E-mail Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
STEVEB STEVEB is offline
external usenet poster
 
Posts: 1
Default E-mail Macro


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

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=26938