Send Emails from Excel with VBA and Outlook (With Attachments)
A tested Excel VBA macro that sends personalised Outlook emails from a list — with attachments, CC, a preview mode and a log column.
Read article →Category Archives: Office
Word, PowerPoint, Outlook and Google Workspace tips for faster everyday work.
PowerPoint Presenter View: 7 Tricks for Calmer Presentations
PowerPoint Presenter View: 7 Tricks for Calmer Presentations
Use PowerPoint’s Presenter View to see notes, the next slide and a timer while the audience sees only your slides — plus shortcuts to…
Read article →Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
Read article →Power Automate: Save Email Attachments to OneDrive Automatically
Power Automate: Save Email Attachments to OneDrive Automatically
Build a Power Automate cloud flow that saves attachments from specific Outlook emails into OneDrive or SharePoint folders — with filters, date folders and…
Read article →Outlook Rules and Quick Steps That Actually Clean Your Inbox
Outlook Rules and Quick Steps That Actually Clean Your Inbox
Set up Outlook rules, Quick Steps, search folders and a few smart habits so your inbox sorts itself — with real examples for reports,…
Read article →Google Sheets QUERY Function for Excel Users
Google Sheets QUERY Function for Excel Users
Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…
Read article →Outlook Calendar Tricks for Busy Weeks
Outlook Calendar Tricks for Busy Weeks
Practical Outlook calendar features: Scheduling Assistant, shorter meetings by default, a second time zone, focus blocks, propose new time, sharing and quick keyboard shortcuts.
Read article →PowerPoint Slide Master: Fix Every Slide in One Place
PowerPoint Slide Master: Fix Every Slide in One Place
Stop formatting slides one by one. Use PowerPoint’s Slide Master to control fonts, colours, logos and layouts for the whole deck — and rescue…
Read article →Mail Merge from Excel to Word: Letters, Emails and Labels (Step by Step)
Mail Merge from Excel to Word: Letters, Emails and Labels (Step by Step)
Send personalised letters, emails or labels from an Excel list with Word Mail Merge — including number and date formatting fixes that trip everyone…
Read article →Word Wildcard Find & Replace: 8 Patterns That Save Hours
Word Wildcard Find & Replace: 8 Patterns That Save Hours
Word’s wildcard search is a hidden power tool. Eight ready-to-use patterns to fix spaces, dates, phone numbers, brackets and formatting in long documents.
Read article →Word Styles and an Automatic Table of Contents (Step by Step)
Word Styles and an Automatic Table of Contents (Step by Step)
Use Word’s Heading styles to format long documents consistently, build an automatic table of contents, number headings and navigate with the Navigation Pane.
Read article →