HI All,

We required to send mails with attachment to different people every month.

we are using "From" option in outlook to send mail from one common login id.


i have created a excel file with following details.

column A: Login ids for "From" field in outlook.
Column B : recipient names separated by comma for "To" field of outlook
Column c : recipient names separated by comma for "CC" field of outlook
Column D : recipient names separated by comma for "BCC" field of outlook
Column E : text for "subject" field of outlook
Column F : text for "BODY" of outlook mail
Column G : contain path and name of the files which needs to attach with mail , files would be in .Zip format and it can be one or group of files separated by commas


could you please help me to write code which use above excel database and sends mails and save the mail in sent folder of outlook?

Regards,
Dharmesh

Here is a hint

http://vbadud.blogspot.com/2007/04/v...-vba-mail.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

thanks for the link but the codes on the link shows static message.

but our requirements are different recipients in TO, CC , BCC , subject line and body of the mails as store in excel sheet.

also we need to attach specific files in .zip format with every mails so data should be taken from excel sheet.

could you please help with consideration of above requirements?


thanks for your support in advance