[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

using VB to enter values into a calander appoinment

Posted on 2011-02-18
2
Medium Priority
?
311 Views
Last Modified: 2012-06-27
i wantt o enter some values into a calander appoinment using a macro,  i think i am missing something simple

i have this

    Dim SubjectName As String
    SubjectName = InputBox("Paste the subject of the ticket")
    AppointmentItem.Subject = SubjectName
0
Comment
Question by:jimcrint
  • 2
2 Comments
 
LVL 1

Accepted Solution

by:
jimcrint earned 0 total points
ID: 34931351
OK I got that bit working now I want a bit more,  I had already done this in an access form and didnt make the connection that the same system worked.

When i have the appoinment open the cursor is sitting on location I want it to sit at the start of the body (above my ticket reference)  i do this in access with gotocontrol and selstart but i cant do that here I dont think  

    Dim NewLen As Integer
    Dim myOlApp As Outlook.Application
    Dim myApptItem As Outlook.AppointmentItem
    Set myOlApp = New Outlook.Application
    Set myApptItem = myOlApp.CreateItem(olAppointmentItem)

    Dim SubjectName As String
    Dim TicketID As String
   
    TicketID = InputBox("Enter the ticket number")
    SubjectName = InputBox("Copy and Paste the subject of the ticket")

If Not IsNull(TicketID) Then
    myApptItem.Subject = SubjectName & ":  Ticket ID = " & TicketID
    myApptItem.Body = Chr(13) & Chr(13) & "[Ticket Notes ~ticRefId='" & TicketID & "']"
    myApptItem.Display (Modal)
End If
0
 
LVL 1

Author Closing Comment

by:jimcrint
ID: 35286869
I found out what I needed to do by experimentation
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome back!  My apologies for taking so long to write part two of this series; it's been a long time coming!  As I promised in Part 1, this article will focus on how to locate those elusive AD properties that you are searching for.  Why is this us…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question