Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTOMATING E-MAILS
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTOMATING E-MAILS
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening e-mails | Excel Discussion (Misc queries) | |||
to many e-mails | Excel Programming | |||
send e-mails | Excel Discussion (Misc queries) | |||
e-mails addresses | Excel Worksheet Functions | |||
Automating swnding mails using macros on Excel. | Excel Worksheet Functions |