I am developing a model which creates individual documents (remittance
advices), be filtering appropriated data for each supplier, collecting it in
a standard format.

I can do all of this using For.. Next loops, but the part I cannot get the
macro to perform is copying an email address into the e-mail address cell
above the worksheet. Is there a method in Visual Basic for doing this kind
of action ?

Ron de Bruin (MVP Excel) has an excellent web page for sending mail..

http://www.rondebruin.nl/mail/folder1/row2.htm

includes many code samples for different scenarios. great work





"BILLROT" wrote:

> I am developing a model which creates individual documents (remittance
> advices), be filtering appropriated data for each supplier, collecting it in
> a standard format.
>
> I can do all of this using For.. Next loops, but the part I cannot get the
> macro to perform is copying an email address into the e-mail address cell
> above the worksheet. Is there a method in Visual Basic for doing this kind
> of action ?