PDA

View Full Version : Solved: Send mail to 100 mail address



slamet Harto
10-21-2008, 08:40 PM
Hi there,

Hope you are doing well.

I've some problem to developing new function in my project.
We want to send an invitation using word doc to 100 mail addresses.
So, we have 2 files which are 1 excel file master with containing of 100 client email address and 100 document files (Ms Word) with containing of invitation letter.

Example in excel file master:
A1. slamet@yahoo.com
A2. Johan@yahoo.co.id
A3. wandi@nvs.go.id
and so on... until 100 lists mail address.

In a folder :D\My Document .. we have 100 files of Letter invitations.
and we just given the documents name with invitation-1, invitation-2 etc.

I usualy using excel to create mail merge and send the active sheet into some email address. Now. I really confusing to approche it. Since, we use 3 applications (word, excel and outlook)

Please kindly help and many thanks in advance.
Rgds, harto

Endorphin
10-21-2008, 11:19 PM
Have a look at this page, I had to do somthing along the same lines.

Neil

http://www.rondebruin.nl/sendmail.htm (http://www.rondebruin.nl/sendmail.htm)

slamet Harto
10-22-2008, 12:20 AM
Fantastic and worked as my dream. Perfect!

Thanks so much Neil and Ron's

Best regards, Harto