gmail

Apologies if this is completely basic, but I can't find anything in the forums that directly relates to what I'm trying to accomplish. I am not at all schooled in anything VBA, technical Excel, etc. I just Google to figure things out, and here I am! Here's my starting point: I have a workbook...

I’ve found many VBA resources to send an email using Gmail on a Windows machine. These all involve activating the Microsoft CDO for Windows 2000 library in References under the Tools drop-down menu of the VBA editor. Unfortunately, this library does not exist on a Mac. Does anyone have the...

I want to send different files for different people with Gmail using excel. Everything is well except when sending the attached items, it goes like this: Person A receives File A Person B receives File A and B Person C receives File A, B, and C it should be: Person A receives File A Person B...

I am adapting some code to make a mail merge work directly from Excel using a Gmail address, but I am having some problems. Any help would certainly be appreciated. I want this to send an email to every column that does not equal "not scheduled this week" in column "I" my info is in the...

Any gmail examples out there that permit the ".Display" option instead of ".Send"? I've searched DeBruin and several sites. Looking for a work around or option that would enable reviewing emails and manually sending. Thanks.

What I am trying to do is to send multiple emails to multiple clients with a click of a button, with each client has a different attachment. I can already send an email with an attachment, however, the second recipient also received the previous attached file sent to the first client prior to...

Hello, I never had this happen before, can't figure out what I am doing wrong. I have a excel sheet that looks like this...(note the blank columns) But when I paste into an email, it looks like this...(note the spaces are no longer separated) DateTypeDebit"CheckNumber"...

I have setup a file that automatically generates emails and sends them directly from gmail account. Unfortunately I only know how to do this using the CDO reference which is not available for MAC users. I need my code to work for both windows and mac user. Does anybody know how to do this...

Hello, is there a way to keep the default signature associated with my gmail account when sending an email from Gmail through VBA (I am using CDO if that can be helpful). Below is the bit of code relevant to the email configuration: everything works fine except for the missing signature. Any...

Hello, I am working on a macro that identifies the username, asks for the account password and sends out an email from Gmail. I tested it using my personal gmail account and worked like a charm with the default settings smtp.gmail.com and port 25. However, I couldn't manage to make it work...

Pls can someone pls help with a vba macro to enable send me auto remainder from excel to gmail of my boss

Hi Excel Guru's, I am having trouble with html borders when the email is read via gMail (Outlook/Apple Mail Client both read it). I googled and there wasn't much info, other than someone suggesting I change the .BodyFormat = 2 (or 'olFormatHTML)...which didn't work :( Please help me figure this...

Hi, can anybody help me with task to check if email address is correct? I dont mean format, but if it bounces without sending an email. There are online services to do that for some price so it is possible to do it somehow(they were correct for my company mail, personal mail, gmail etc.). So...

Hello: I have figured out how to send a gmail or outlook email, adding spreadsheet ranges to the email body, and adding file attachments to the email using vba within excel. The one thing that I cannot figure out (and have searched extensively), is how to create a gmail draft and not send it...

Hi, Please find the VBA code i am using to send mail.Getting error .(Run time Error '-2147220975(80040211)' : The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available) Tried to disable two step verification and enable...

Hi, I have a .txt file of around 700 contacts (email addresses only) each separated by a ','. As I am unable to import a .txt file to Gmail I have imported these contacts into a CSV file via Excel. However when I try to import this into Gmail the import fails. Could anyone please tell me...

We recently migrated from Outlook to Gmail. My Access VBA utility that sends emails had the feature of including the Outlook signature. Unfortunately I can't figure out how to include the Gmail signature in code, i.e. there is no equivalent to the Outlook code OutMail.HTMLBody = body &...

Dear Sir or Madam: My name is Markus, and today is my birthday. Therefore, I am hoping Mr. Excel can provide me with a very special birthday gift. I am a teacher who is trying to send Excel student grades via Gmail to students and their parents. I don't want to involve a another component such...

I'm presently working at Salesforce in San Francisco and there was mail merge tool in google docs that is no longer supported by the company. Is there a way to create a mail merge from GMail (SFDC doesn't use Outlook - it uses GMail for all internal communications). I know you can send...

Hi On my worksheet I have email addresses in column A and text in column B. Not all cells will have an entry in column B. These are results generated from a separate sheet using a formula Is there a formula I can use to launch the email address via gmail if Column B contains specific...