| You Can Automate Your Microsoft Office in About 60 | | | | and then show the addresses in the Worddocument. |
| Minutes | | | | Also, we can write an application to use Word |
| Copyright © 2005 Tenny Ing | | | | toautomate Outlook for reading the contact and any |
| Viccomp, Inc. | | | | other data inthe Contact or other folders. Or, we can |
| Microsoft Office program is a programming tool called | | | | use Outlook to read in |
| Visual | | | | Word or Excel scheduling list and use it to schedule |
| Basic for Applications (VBA) that comes with | | | | tasks in |
| Microsoft Excel, | | | | Outlook. |
| Word, Outlook, Power Point, and Publisher. VBA can | | | | Writing VBA programs is quite straightforward and |
| make yourrepeating jobs automatic. It also can | | | | can be learnedin a short period, providing that there are |
| customize Excel, Word andother Office procedures | | | | tutorials that arewell organized and illustrated with |
| for your own needs. >From Office version | | | | many pictures. After goingthrough a few tutorials, the |
| 2000, all the Office programs are equipped with VBA. | | | | learner can explore on himself orherself the other |
| Hand-On experience is the key to be a good | | | | possibilities with the programming. Learningprogramming |
| programmer. | | | | is not as hard as people think. Rather it can be afun |
| Programming tutorials are the easier way to learn any | | | | experience to see the programs work. |
| computerprograms including VBA. For example, a | | | | Besides we need to be good at writing programs, |
| tutorial can show peoplehow to use VBA to automate | | | | keeping our |
| (make automatic) an Excel routine likeupdating the | | | | Windows and Office up-to-date is as important. Please |
| fonts and sizes for a range of cells, orautomatically | | | | rememberto visit Microsoft website to do automatic |
| pops up a calendar for selecting a date. VBA canalso | | | | Windows and Office |
| be used as a tool to automate Word mail-merge or | | | | Update at least once a month, which will assure you |
| create atext file from a Word document. VBA can | | | | have thenewest fixes and updates. |
| even be used as a toolto automate email alert in the | | | | There are a few free VBA learning tutorials at If you |
| Outlook Inbox or scheduling taskto do. | | | | would like to learn beyond the freetutorials, you can |
| VBA can make one application like Excel work with | | | | sponsor us with the other low cost tutorials. |
| anotherapplication like Word and Outlook, or any other | | | | You can also request a tutorial for your own needs |
| combination. Tomake Excel work or control Word is | | | | with therequest entry of the Contact page. |
| called Excel automates Word. | | | | See how Viccomp's tutorials can show you how to |
| Likewise, Word works with or controls Outlook is | | | | write your first |
| called Wordautomates Outlook. | | | | Office program ==> |
| There can be many applications of automation that | | | | Just download the free tutorials to try, or more tutorials |
| was introducedin the previous paragraph. For example, | | | | fora small fee. Please use the Contact page for your |
| we can write a VBAapplication to make Word read | | | | request ofa tutorial or programming. |
| an Excel address list that is savedin a spreadsheet, | | | | |