View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_49_] Bob[_49_] is offline
external usenet poster
 
Posts: 1
Default Open Outlook from Excel and send attachments

Hi,
Can someone send me a solutions for this or point me to a website where i
can find information for this.

I have an Excel 2002 sheet with two columns.
Column A is plain text, with an explanation about a certain PDF document.
Column B contains an hyperlink to a PDF document

In column C, i want to put, for example an 'X', after the documents which I
want to send with Outlook 2002.
Is it possible to write an Excel macro, which scans the column C looking
for the cells with an 'X' in it.
Then start Outlook and insert the documents, that the hyperlinks from
column B point to, as attachments.
Of course only the documents with an 'X' in column C.
The recipient and subject line doesn't have to be filled in.

Kind regards,

Bob