excel -senior vba lesson ,from 0 to 100

							                               VISUAL BASIC FOR APPLICATIONS
                                EXAMPLE ONE FOR VBA TUTOR Part Five




This EXAMPLE document demonstrates how to use API calls to either access your email program
from WORD, or to send a message(s) automatically from within WORD using VBA.
It is not necessary to open and close a MAPI session, but it is good programming to do so. In a “real”
program, you would not have to include the Mapi started and MAPI finished messages.



                   Email Functions for a single message!
E-mail Address to use ~               garyradley@standard.net.au
Subject ~                             SENT WITHOUT USER INPUT FROM WORD!
Message to send ~                     This message was sent automatically using VBA!




                  Email Function for multiple messages!
NAME:           SUBJECT: MESSAGE:                 ADDRESS:
Gary Radley     Hi       Message 1                garyradley@standard.net.au
Gary C          Hi       Message 2                garyradley@ansonic.com.au
Radley




              Read Mail