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
|