• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 70
  • Last Modified:

VBA to update Google Sheet from MS Outlook

I am looking for a way to automate the processing of emails that come to my MS Outlook. At present I copy, manually, the data from the email to a Google Sheet. I can write the VBA to extract the details I need into variables easily enough but is there a way I can open a Google sheet, search for a record (based on a Key field, namely the address which is always in a standard, decipherable format) and update it, or if it's not there, add it to the end of the sheet? I can do this with Excel but I need it to go into Google Sheets.

Rob
0
Rob4077
Asked:
Rob4077
1 Solution
 
Máté FarkasDatabase Developer and AdministratorCommented:
You should start from here: https://developers.google.com/sheets/api/v3
0
 
Rob4077Author Commented:
Thanks. Appreciate the link
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now