|
Free Courseware |
|

Download FREE courseware handouts. These
documents are ideal for teachers, students and anyone wanting to
learn more about their Microsoft Office programs. Each handout
covers a specific topic and is illustrated with full-colour
screenshots. Many have accompanying sample files. The files are
not restricted in any way so you can print copies or read them
on-screen.
Get my Free Courseware here. |
|
|
eBooks |
|

Do you want to learn more about Access, Excel and
VBA? Are you a teacher looking for top quality courseware for your
students? My eBooks are the ideal solution to your needs. They are
packed with code snippets, illustrations and step-by-step
exercises. Written in the same
style as my popular on-line tutorials, my eBooks will help you
develop your skills and build useful, professional looking
applications. Find out more at my eBooks Page. |
|
|
Support this site! |
|
Make a small donation to help
support this site.
|
|
 |
-
A Pop-up Calendar for Word - Part 1: A Simple
Calendar
Word's Insert Date tool will insert the current date into your
document in a choice of formats, but it doesn't provide you with a calendar.
This tutorial shows you how to use a VBA UserForm to create a handy pop-up
calendar that you can call from a keyboard shortcut or from the right-click
menu.
-
Using Ask Fields in a Word Mail Merge
Sometimes you need to run a mail merge and include information that isn't
included in your data source. Perhaps it is different for each addressee, or
changes each time you run the merge. Fix it with Ask fields.
-
Using Query Options in a Word Mail Merge
You needn't send your mail shot to everyone on your list! As your
database grows you will want to choose who to mail to, and perhaps sort your
letters into a particular order. The good news is that Mail Merge has a tool
for this, Query Options, and you don't need to interfere with your database.
More Word tutorials from my VBA section...
- Build an Automatic Document Template for
Word
Any frequently-used Word document can be saved as a template that creates
a fresh copy of the document whenever it is needed. Letters, contracts and
other standard documents created from templates usually need modifying in
various places before being printed and saved. This 3-part tutorial shows
you how to build a VBA UserForm to create a friendly dialog box to
automate this process and help the user complete the task.
Word Questions from my Mailbag section...
|
|
^ top
|
| |
 |
|