Request to provide VBA code for excel 2003 for sending mails with attachment
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?