Holiday request form

Status
Not open for further replies.

JoeC

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi,

I'm looking for some info on how I could go about creating a holiday request form for outlook.

I have found some examples, but none were what I need.

A user needs to be able to fill out the form, and have the form automatically send an email to the line manager to either accept or deny the request. Once accepted, the form will need to be emailed to another person in HR, and also get placed in multiple calenders.

I have done other programming such as Visual Basic, .Net etc, but I really don't have much idea on the VBS for outlook.

Any help would be brilliant.

Thanks!!
 

JoeC

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Do you use InfoPath in the company? That tends to be easier to implement than outlook forms.

Thank you for your reply.

It's actually to be implemented in multiple companies over time, so really would prefer to use outlook forms.

I have managed to use some add-ons to create the date range that displays a small calendar, but that is as far as I have got. Is it possible to have the form automatically add the holiday into the calendar?

Thanks!

Joe

EDIT: I do have access to use info path, but I'm not entirely sure the other companies I would be implementing it on would have it. If it can ultimately be used on outlook that would be perfect.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The form, or more accurately, code behind the form, can create the calendar entries. It will need to be published in the organizational forms library due to the code.
 

JoeC

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The form, or more accurately, code behind the form, can create the calendar entries. It will need to be published in the organizational forms library due to the code.

That would be fine.

Do you know of any examples I could look at that would:

  1. Send email to Manager of person requesting holiday, with Approve / Disapprove
  2. Once the Manager approves, To forward the form to HR, and add the holiday into multiple calenders
  3. Also send message back to the user to let them know the holiday was approved

Thank you

Joe
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I thought outlookcode.com had a sample but I couldn't find it last night. Microsoft used to have one but I can't find it online or a backup offline.
 

JoeC

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I thought outlookcode.com had a sample but I couldn't find it last night. Microsoft used to have one but I can't find it online or a backup offline.

Thank you for your reply.

Do you have any example for code that could at least send an email? So I could have the form automatically send an email to several people?

Thanks

Joe
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
ending email via code is easy - this is the basic code and it can be tweaked to generate the message when something happens or to use a template instead of a new message form.

Code:
Sub CreateMail() 
 
Dim oMail As Outlook.mailItem 
 
Set oMail = Application.CreateItem(olMailItem) 
 
With oMail
   .To = "me@here.com"
   .Subject = "The Subject"
   .Body = "The body"
   .Display ' use .send to send it automatically 
 
End With 
 
End Sub
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
O Outlook Holiday Request Form Design Using Outlook 0
J Unwanted US Holiday Contact folder in Outlook.com syncs to MAPI/Phone Address book Using Outlook.com accounts in Outlook 9
G Outlook 2013: Cannot Edit default Holiday Calendar Using Outlook 2
A Delete all appointments on calendar for week of holiday / annual leave Using Outlook 1
Mark Foley The upload of "Calendar" failed. There was a problem with the request. Using Outlook 6
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
S Accepting meeting request from calendar keeps the meeting request in the inbox Using Outlook 2
D Add all meeting rooms to the meeting request by default Outlook VBA and Custom Forms 0
G Auto accept meeting request for non primary account Outlook VBA and Custom Forms 1
T Double clik behavior on agenda open a new meeting request Using Outlook 1
Diane Poremsky Autoaccept a Meeting Request using Rules Using Outlook 2
Diane Poremsky iPhone and the Meeting Request Bug Using Outlook 0
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
Diane Poremsky Task Request Status Update Address Missing Using Outlook 0
Diane Poremsky How to Create a Pick-a-Meeting Request Using Outlook 0
D Meeting Request - Too Many Recipients Using Outlook 0
D Leave Calendar Request Triggers To Supervisors Using Outlook 1
O How to send outlook meeting request as attachment Using Outlook 3
I Multiple events in single request Using Outlook 6
N Outlook meeting request decline behavior Using Outlook 1
S Open custom meeting request with checkbox Using Outlook 0
D Restore Delete Calendar Meeting Request Using Outlook 3
S signature in meeting request Using Outlook 2
J How create an .ics file with a multiple apointment request Using Outlook 0
M Room Reservation request showed "None" in Tracking-View Tracking Status. Exchange Server Administration 0
A Issue with respond to an email message with a meeting request Using Outlook 0
T Request Addition to Code- convertMail to AccountAppt (from www.Slipstick) Using Outlook 16
F Creating Meeting Request Custom form and distribute it to domain user HELP!!! Using Outlook 0
F Creating Meeting Request Custom form and distribute it to domain user HELP!!! Using Outlook 0
G Request Form Using Outlook 2
J Exclude myself in meetin request Using Outlook 0
J Outlook Contacts: How to filter contact phone numbers from a cti request Using Outlook 1
J outlook meeting request random people are deleted Using Outlook 2
R How to show Sent Date in Meeting Request printouts Using Outlook 1
P Not able to receive meeting request Using Outlook 2
G Autoaccept/autodeny meeting request after crosscheck with calendar Using Outlook 1
B Outlook Calendar - Time zone changes after the meeting request is accepted. Using Outlook 1
L Need to Delete One Attendee from Meeting Request Without Resending the Request Using Outlook 1
R Disable request to share a calendar Using Outlook 1
P Time Off Request - not posting to public folder once approved Using Outlook 0
E Outlook invitation request mail sending twice problem Using Outlook 1
M How can I send task request using vCalender/VTodo component using C# Using Outlook 2
M How can I send a Task Request using vCalender/vTodo format using C# Using Outlook 3
K Print "scheduling assistant" data on meeting request? Using Outlook 1
D Sending Multiple Meeting Dates in One Meeting Request Using Outlook 4
Diane Poremsky Error: 5102. Server. Maximum request length exceeded Using Outlook.com accounts in Outlook 0
S use the custom form to show meeting request in recipient's calendar Outlook VBA and Custom Forms 1
D Tracking meeting request responses in Outlook Outlook VBA and Custom Forms 16
T Custom Task Request Deployment Outlook VBA and Custom Forms 5
D 2d help request-problems sharing BCM database BCM (Business Contact Manager) 1

Similar threads

Top