Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Automatic e-mailing (OE or 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> All

    OK I am the secretary of a non-profit group that teaches kids about computers. This means that I am the one who sends the e-mail notification about the up-coming meeting(s) and then after the meeting, I am the one who sends the minutes of these meetings.

    What I am hoping for is write some VBA code that would do the following (with one button <img src=/S/clown.gif border=0 alt=clown width=15 height=15> if possible):

    1) Displays a UserForm where I can pick the committee that is to meet.
    2) Allow me to add the date, time, place and some comments about the meeting.

    Then the OK button will:

    3) Fire an e-mail to all members who are on this committee.
    4) Place a To-Do action on my To-Do list, say a couple of days later, about finishing the minutes and then fire these to the members who are on the committee.

    Now I have multiple committees and that means the system needs to know all about these lists of members.

    I am good with VBA in MS-Excel, so I think I can do the work, but I need a starting point specially with Outlook or Outlook Express's object model.

    Thanks for any help <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mailing (OE or 2000)

    Wassim

    You've created a pretty good description of standard "organising a meeting" functionality - I struggle to see what VBA will add.

    Why not simply use the calendar and create a meeting using normal Outlook tools - everything you describe will be possible by suitably setting items as Outlook will happily mail meeting requests to 'external' participants. You participants can be members fo distribution lists whioch makes selecting them really easy.
    So

    1) Displays a UserForm where I can pick the committee that is to meet. --> Double-click on a date/time range in calendar
    2) Allow me to add the date, time, place and some comments about the meeting. --> see above

    Then the OK button will:

    3) Fire an e-mail to all members who are on this committee. --> Send does this
    4) Place a To-Do action on my To-Do list, say a couple of days later, about finishing the minutes and then fire these to the members who are on the committee. --> meeting reminders and alerts can be set for this

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Automatic e-mailing (OE or 2000)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Andrew

    OK it is obvious that I do not know MS-Outlook that much <img src=/S/duck.gif border=0 alt=duck width=23 height=23> . In fact I would like to uninstall it just because I don't use it.

    I guess I will start using it and learning about it more.

    OK would it be too much to ask to give me a primer, where you would describe the process in a bit of details? Give me a couple of days to fire the software up and check it.

    BTW does MS-Outlook and MS-Outlook express function the same? What is someone only has OL Express?

    Thanks again

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mailing (OE or 2000)

    Wassim

    For simple Mail messaging, Outlook and Outlook Express are pretty much the same.
    Outlook Express is the better at News serving.

    In other repsects, Outlook has more functionality than Outlkook Express:
    a) VBA and an object model
    [img]/forums/images/smilies/cool.gif[/img] 'Office' functionality and interoperability
    c) Calendar / Meeting functions
    d) Task lists

    I actually use both - Express for Newsreading, and Outlook for the rest.

    Its pretty easy to test out the calendar functions.
    Click on the Calendar folder and highlight an area of the day (drag mouse over it)
    Click the New appointment Icon on the toolbar
    File it in with subject and content,

    Effectively, this is a combined "Appointment" and mail message. You can invite people to the meeting and attach documents.

    If others don't have Outlook then the mail message is formatted as a simple text message so that they will see the appointment request.
    This can be set on a per-user basis within the contacts folder.
    If you want to test it across the net, feel free to invite me to test meetings - I'll reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •