Learn Data Analysis
  • Home
  • Python
    • Pandas
    • Matplotlib
    • PyQt5
    • Google Tasks API
    • Google Sheets API
    • Google Gmail API
    • Google Photos API
    • Google YouTube API
    • Google Translation API
    • Google Vision API
    • Simple-Salesforce
    • win32com
    • xlwings
  • Excel
    • VBA
  • Office
    • Access
    • Outlook
    • PowerPoint
    • Word
  • Trailhead
  • About Me
Select Page

Send Email From Your Gmail Account with VBA

May 2, 2019 | Access, Excel, Office Automation, Outlook, PowerPoint, VBA, Word

Gmail, the world most popular email service developed by Google. Today just about almost everyone owns a Gmail account. We know it is pretty easy to create a VBA script in Microsoft Excel to integrate with Microsoft Outlook, from there, we can send an Outlook email,...

Retrieve Email Information From Subfolders with Outlook VBA

Apr 30, 2019 | Office Automation, Outlook

In this tutorial I will show you how to write the VBA script to retrieve emails’ information from subfolders underneth the Inbox folder.Mailitem object documentation. data-ad-layout="in-article" data-ad-format="fluid" data-ad-client="ca-pub-3255865697013143"...

Automate Mail Merge to Save Each Record Individually with Word VBA

Apr 11, 2019 | Office Automation, Word

Mail Merge is a really useful feature built-in in Microsoft Word to create letters, labels, envelopes, or even drafting email in bulk. But not everything is perfect. One of the drawbacks with mail merge is that when you try to print each record as a single PDF file,...

Pull Outlook Emails’ Detail Into Excel Using VBA

Apr 7, 2019 | Office Automation, Outlook

Microsoft Outlook is probably the most popular personal organizer system today competiting with Google’s gmail. One of the major request I have frequently getting is “How do you write a VBA automation to quickly export Outlook Email detail into a Microsoft...

Create a Macro To Export All The Images From Your PowerPoint File

Apr 5, 2019 | Office Automation, PowerPoint

Sometimes when you receive some really amazing PowerPoint presentation file, and you see some of images you would like to reuse for future presentation but you don’t want to go through the hassle manually save each image one-by-one, and export them to your PC.In...
Page 2 of 2«12

Search Post

Subscribe My YouTube Channel

Other Posts

  • Access (3)
  • Automate Google Tasks API with Python (4)
  • Automation Scripts (8)
  • Data Analytics (8)
  • Data Visualization (10)
  • Excel (39)
  • Excel General (11)
  • Google API (General) (2)
  • Google Calendar API (2)
  • Google Drive API (2)
  • Google Gmail API (2)
  • Google Maps APIs (1)
  • Google Photos API (6)
  • Google Sheets API (12)
  • Google Translation API (2)
  • Google Video Intelligence API (1)
  • Google Vision API (15)
  • Google YouTube API (7)
  • LeetCode (1)
  • Matplotlib (7)
  • Microsoft SQL Server (3)
  • Office Automation (11)
  • Other Tutorials (1)
  • Outlook (7)
  • Pandas (5)
  • PowerPoint (3)
  • PyQt5 (91)
  • Python (204)
  • Resources (1)
  • Salesforce Trailhead (33)
  • Simple-Salesforce (4)
  • Uncategorized (6)
  • VBA (27)
  • Web Scraping (1)
  • win32com (2)
  • Word (4)
  • XlsxWriter (4)
  • xlwings (5)
Copyright © LearnDataAnalysis.org