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 ?