Macro sending with mailto linkup to other sheets

[ragil.yudy]

Dear Expert,

i've try to make system looks like vlookupmail address in macro sending...but found a VB problem... :confused:

i just can make that be easy by provide a column that contain mail address for mailto in the same sheets for mail contents.
anybody could help me for these case?

here is a link of some macro sending models
http://www.rondebruin.nl/sendmail.htm

[Excel Fox]

Ragil,

Can you rephrase what exactly do you want to achieve. Can't make out from what you've mentioned above.

[ragil.yudy]

419

this is the result for auto sending.

in this macro patern, for every row contains that have same toaddress (mail destination) will be sent in on time sending.
with ccaddress will be based on other sheets( mail sheets),

the major problem was, email address sources in this macro are provided in 2 kind :

loginName to email address
vendorname to email address

is there any perspective for this macro?