Hi,

My workplace have dropped a bombshell and done a runner.

They are swapping from MS Exchange to Google GMail. Not too much of a problem.

Well there was a niggle of a problem. Some of the VBA coding I look after (in Excel and Access) generates emails. Auto reports and sends with attachments. I thought this might be a problem, but shelved it.

Wish I'd asked someone now cause its going live next week

I thought that MS Outlook could possibly be tied to gmail, a back up plan. This got shot down in the last 30 mins cause the outlook is locked down and I wont be able to get it to talk to GMail (Imap disabled - security policy or something).

The people in the know say they cannot give more bandwidth (uh?) and I should look at using SMTP. They can provide a server address.



So, finally - my question and a request.

qs: Can VBA talk with SMTP server?

Can you provide any links to read up on how to do this including attachments?
If it need API I would need the calls and I will go n investigate.

Thanks in advance