+ Reply to Thread
Results 1 to 2 of 2

Excel + Outlook + Gmail: I want to use Gmail Schedule Send instead of Outlook Delay

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    California
    MS-Off Ver
    MS 365
    Posts
    2

    Question Excel + Outlook + Gmail: I want to use Gmail Schedule Send instead of Outlook Delay

    Hi,

    I built a mail merge spreadsheet with a macro that send personalized and delayed emails according to their timezone using Excel and Outlook. It works fine.
    My email provider is Gmail.
    When I send a campaign with 1000+ emails, I have to keep my computer running for days.
    Gmail has a function to schedule emails.

    Instead of staging my emails to be sent in Outlook, is it possible to have the macro to stage these emails on the "Scheduled" tab in Gmail?
    Or is there a MS solution that I ignore that would allow me the same thing?
    I don't mind migrating to MS365 if needs be, and this way, all my emails would be in the cloud after I create them and I wouldn't/t have to keep my PC on forever.

    Thanks for your help!
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    02-25-2022
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Excel + Outlook + Gmail: I want to use Gmail Schedule Send instead of Outlook Delay

    Outlook has to be running to send emails so your PC needs to be running. I've used Azure Function Apps to send emails using my Outlook account. I have a database with email details and templates. I schedule the Azure Function app to run every 5 minutes, queries database for emails to send, sets up template and sends email. I wrote everything in C#. I used Azure SQL DB for the database. I ran everything on my home PC initially to get it running but easily moved it to the cloud.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using Outlook for email and Gmail as the client, seeing Outlook Contacts on my iPhone
    By cheddarthief in forum Outlook Formatting & Functions
    Replies: 5
    Last Post: 10-17-2022, 09:25 PM
  2. How to read gmail without outlook
    By patel45 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2019, 05:33 AM
  3. Email the active worksheet via Gmail (instead of outlook)
    By JamesReyes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2018, 08:14 PM
  4. get a workbook in excel to email out through gmail not outlook
    By emussynski in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-21-2016, 12:19 AM
  5. Send Workbook with Gmail not Outlook?
    By excelji in forum Excel General
    Replies: 1
    Last Post: 07-28-2014, 10:18 PM
  6. How to add your Gmail account to Outlook 2012 Using IMAP
    By JiniOnline in forum Tips and Tutorials
    Replies: 1
    Last Post: 06-05-2013, 03:20 AM
  7. Get Excel to use gmail like it does Outlook
    By nemmi69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2012, 04:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1