Resources to help you when using CDO.sys to create email with ASP and VbScript

Introduction

Currently working on a simple form that emails to a nominated email address which uses  Classic ASP and VbScript. I normally use JMail or similar components installed on IIS depending on what the hosting service has available.

In this case I am using CDO.sys which is native to IIS to achieve the same result.

So having gathered some useful CDO.sys resources and samples, I thought I’d share them via my blog. Continue reading “Resources to help you when using CDO.sys to create email with ASP and VbScript”

Windows 7 Features and coming posts

Windows 7 New Features

Running some Windows familiarisation  sessions shortly, so I thought I’d share some resources and my favourite aspects of Windows 7. Continue reading “Windows 7 Features and coming posts”

Using Outlook Contacts In Word

Here are three ways to use Outlook Contacts in Word

Method One

In a Mail Merge to generate a batch of letters or labels – see full article at Microsoft.

Continue reading “Using Outlook Contacts In Word”

Outlook – removing auto complete entries from “to:”

When composing an email in Outlook, you often have old or incorrect addresses showing up when you start typing in the To box. This article at Office.com shows how easy it is to remove these.

http://office.microsoft.com/en-us/training/change-what-shows-up-in-autocomplete-RZ001050596.aspx?section=7

Regards

Steven

SharePoint 2010 Datasheet view not available

Currently spending some quality time with SharePoint  2010. I ran into a problem with the datasheet view. Found a couple of useful blogs as well as the solution. Continue reading “SharePoint 2010 Datasheet view not available”

Setting up Sharepoint

I am preparing for moving back into   SharePoint study and need to build some Virtual machines with SharePoint 2007 and 2010 to facilitate this.  I have had an amateur attempt at this a few months back and struggled due to lack of preparation. So this time I decided to start with a search for set up articles and this list is the result.

Continue reading “Setting up Sharepoint”

VLOOKUP tip sheet and more

I am often recommending the Microsoft Excel Blog as a useful resource to intermediate and advanced excel users. They have some good VLOOKUP articles there, that are worth passing on: Continue reading “VLOOKUP tip sheet and more”

How do you get a sheet name to print in a Cell?

This question often comes up when I am showing how to link between sheets. Continue reading “How do you get a sheet name to print in a Cell?”

Excel resources for 77-602

General Advice

From my recent experience with another exam certification process I recommend:

  • Learn the software thoroughly
  • Poke around in the features you don’t use much
  • Learn the names of menu options and icons and the sequences to get to key tools
  • Don’t overlook the big picture – when and why  to use a particular tool or function
  • Use the exam objectives to identify your weak areas
  • Do as much hands on as you can to reinforce learning from courses and reading

Continue reading “Excel resources for 77-602”

Over 1000 views

My YouTube channel has had over 1000 views. I know movies of cute puppies will get  this many views will get that many views in 10 minutes… but its a big deal for me. So see Excel, Word, PowerPoint, Acrobat and other tips at http://www.youtube.com/user/TrainAScope

Outlook Exam 77-604: MOS: Using Microsoft Office Outlook 2007

Some notes and resources to assist people preparing for Outlook Exam 77-604:  MOS: Using Microsoft Office Outlook 2007

Continue reading “Outlook Exam 77-604: MOS: Using Microsoft Office Outlook 2007”

Microsoft – Office 2010 New Features E-Book

Go to Microsoft Office – Training Portal look for the Special Offers section – you will find a special offer for an e-book. The book is the 202 pages Office 2010 First Look by Katherine Murray which overviews new features across the Office Suite, including some step by step walk throughs. It covers Word. Excel, PowerPoint and One Note, SharePoint and Access. It is available as in PDF or XPS formats.

You will need to create Windows Live ID and sign in. I’d recommend an explore of the Training Portal while you are there.

Steven

Useful MS Word Links

This is a quick collection of useful word links  for Word 2007 or later. Not a pretty document but some useful links

Movies

My You Tube Channel has a few Word related movies on it.  Don’t forget You Tube for specialist content like Word. For example, YouTube has 500+ movies on Word 2007 and forms. More Links after the fold.

Continue reading “Useful MS Word Links”