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 (e-mail address removed)
sample1234ORACLE (e-mail address removed)
sample12233ORACLE (e-mail address removed)
sample123434ORACLE (e-mail address removed)
sample12343ORACLE (e-mail address removed)
sample1223434ORACLE (e-mail address removed)



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

John

 

[Guest]

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