Send mail to addresses from excel with parameters

[pl.godles]

Hi,
I have an excel file, in which I have personal details, such as: email
address, name and name of the report they receive. I would like to
know how to create an email that will iterate trough the rows in excel
and send email to a person from current row using name of a report
also in a current row. In other words, one email should be sent to one
person with one name of the report.

An Excel file looks similar to the one below.

REPORT_NAME EMAIL
sample123ORACLE [email protected]
sample1234ORACLE [email protected]
sample12233ORACLE [email protected]
sample123434ORACLE [email protected]
sample12343ORACLE [email protected]
sample1223434ORACLE [email protected]



I would be very grateful if someone would give me the details how to
proceed with this.
Thanks in advance.

John

 

[Eric Legault [MVP - Outlook]]

See this code sample:

http://www.outlookcode.com/codedetail.aspx?id=788

It illustrates how to load an Excel workbook and iterate through the
contents to create appointment items. You can easily modify it to create
e-mail items instead.

 

[pl.godles]

See this code sample:

http://www.outlookcode.com/codedetail.aspx?id=788

It illustrates how to load anExcelworkbook and iterate through the
contents to create appointment items. You can easily modify it to create
e-mailitems instead.

Thank you very much it really helped me alot