Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Books
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Articles

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (10)
    Word - VBA Programming (8)
  • Outlook - General Tips

    Easy Outlook Email Integration 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2012-01-22 05:52 AM     Number of Views: 28862 

    Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I ended up heading off to a site to copy an example (usually from my colleague Ron de Bruin's excellent site), then customizing to make it work.

    The goal of this article is to provide an even easier way to add email functionality to your Excel (or any other Office) project... something easy enough for beginner coders to use as effectively as master coders. I wanted a re-usuable chunk that I could just drop into my project with ease, and I believe I've accomplished that here.
    ...
    Read More Read More 3 Comments

    Setting up Out Of Office replies on Outlook 2010 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2011-07-15 09:35 PM     Number of Views: 5596 
    Article Preview

    If you’re running Outlook 2010 and Exchange 2010, you can set up your out of office replies any time during the day, and schedule them to take effect for a certain period. I wish I could do this with my phone… that way I could set it up when I think about it, and then forget about it. Currently I have to set a reminder to change my greeting just before I leave for the day… something that I’ve forgotten in the past due to the inevitable last minute chaos that always erupts just before you’re planning to go away for a week!
    ...
    Read More Read More

    Outlook 2007 Time Saving Tips - Turning Off The Reading Pane 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2008-03-12 09:05 AM     Number of Views: 7997 

    Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook version.
    ...
    Read More Read More

    Outlook 2007 Time Saving Tips - Creating Email Groups 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2008-03-03 08:57 AM     Number of Views: 113818 

    Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook versions.
    ...
    Read More Read More

    Outlook 2007 Time Saving Tips - Creating a Signature File 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2008-03-03 08:48 AM     Number of Views: 11478 

    Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook version.

    Creating a signature file
    In most email ...
    Read More Read More
  • MVP Logo
  • Recent Forum Posts

    guanstan

    The Web Query Table data in excel not the same as displayed online at the website.

    Tomorrow(6 pm my time) I'll REFRESH my 50E.xlsx and compare to online BURSA WEB to see if they match. Thank you for your help. Funny for my 20E.xlsx...

    guanstan Today, 11:40 AM Go to last post
    AliGW

    The Web Query Table data in excel not the same as displayed online at the website.

    That's impossible if you did the refresh correctly, I'm afraid, so it comes down to novice user error, one way or the other. Either way, you have learned...

    AliGW Today, 11:17 AM Go to last post
    guanstan

    The Web Query Table data in excel not the same as displayed online at the website.

    Before I wrote in for help, I have done REFRESH query and compare the EXCEL table to the online Bursa WEB page. They don't match. Previously I used to...

    guanstan Today, 11:10 AM Go to last post
    AliGW

    The Web Query Table data in excel not the same as displayed online at the website.

    OK - so you need to refresh queries! Either do this manually (Data ribbon - Refresh (All)), or right-click your query in the query bar on the right (Data...

    AliGW Today, 10:53 AM Go to last post
    guanstan

    The Web Query Table data in excel not the same as displayed online at the website.

    Yes you are right. I just started this week to use PowerQuery thru articles in the internet here and there. Anyway thanks for your help. I know next...

    guanstan Today, 10:49 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 06:40 PM.
Powered by vBulletin® Version 4.2.5
Copyright © 2019 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it