My company has been using Lotus Notes as it's email client but has now made the move to Google Mail (Google Apps). We are retaining the Lotus client for the short term but there is the understanding that Lotus is going in 12-18 months.

... I use several excel files that produce and send emails (at the moment) via the Lotus Notes client so now I'm stuck !! My problems are compounded because :

a) I'm not an admin and have no access to admin functions
b) we do not have any other client installed (no outlook etc...)

Help ???

Do you mean Gmail? And you have no locally-installed email client whatsoever?

You could try using CDO (see http://www.databison.com/index.php/3...l-using-excel/ for CDO example), but with no mail client you may not even have MAPI installed.

You could try using the Gmail API (http://code.google.com/apis/gmail/) but it requires OAuth and I am not aware of any VBA implementation of OAuth, Gmail or otherwise.

__________________
Regards,
JP
JP SoftTech

Hi,
I want to sent emails through my google spreadsheet which have data like recipient's name,email address,subject.
I have a docs(word) template containing the message body.
I need a script to send emails to each recipients in my spreadsheet with the corresponding subject line and a personalised template( i want to insert variables in my template like the recipient's name to look my email more personalised and impressive)
Can you help me on this.
I actually found a script at the following link but it has not the option to personalise the subject heading. So, you can help me by making appropriate changes in this script.
https://developers.google.com/apps-s...les/mail_merge

Thanks in advance.