VBA to Send E-Mail

[NeedForExcel]

I found a code on a Website which helps send E-mail (File Attached).


I Just had 3 Queries.

1) We do not use Outlook here at office. We use some other E-Mail client (Zimbra). Can we configure that instead of Outlook.

2) Assume if I restructure the sheet so that the E-Mail Address, CC & Bcc are in 1 row, and I have multiple rows with different customers E-Mail ids, (However Subject Line & Message Text remaining same) is it possible to create a loop so that it will send all the mails on its own?

3) Can we include attachments. For example If I have a few excel sheets in a folder, all attachments having a unique name can some logic be applied to accah a particular file an E-Mail is being send to that specific E-Mail id to which the attachment is to be sent?

[gb#]

I've come up against the same problem, and after Googling around for a while found that CDO reference is what I was looking for. Try searching for "send email in VBA with CDO" or something like that.

The following code connects to a gmail account (for example), and send the email without it being displayed (therefore doesn't rely on Outlook)

Please Login or Register  to view this content.

[NeedForExcel]

Alrite thnx.. Ill try searching for it.. Cheers!