Can I set the "Reply To" address before my program sends the Email

[Dave Goboff]

We have an automated E-mail sending macro within an Excel Spreadsheet.
The spreadsheet checks for specific files in a specific directory and
if found, emails the file to a specific address or group. The account
sending the Email is "Servers". We need any replies sent not to
"Servers" but to an account rep. The rep's address depends on which
file is being sent.

I can add the Reply To address into our program by adding the column
to the Excel File.

Is it possible to set the Reply To address within the VBA inside the
macro? If so, which property should be populated?

(I hope that the question is clear, as you can probably tell I'm not a
VBA programmer. Just one of those guys who on occasion opens up code
and horribly modifiles it.)

Thanks

Dave Goboff
(e-mail address removed)