Dynamo Nath
Board Regular
- Joined
- Aug 5, 2009
- Messages
- 142
I've worked out how to do this from Excel but I have hit a snag which is this:
I want the meeting start time to run off of a value in a cell but unfortunately the start time and date share a property and I am unable to combine the two variables together without getting an error. Any ideas or workarounds?
I want the meeting start time to run off of a value in a cell but unfortunately the start time and date share a property and I am unable to combine the two variables together without getting an error. Any ideas or workarounds?
Code:
With trial_notification
.MeetingStatus = olMeeting
.Subject = trial_type & " trial on " & ship_name
.Start = trial_start_time
.Duration = 300
.location = trial_location
End With