Setting up a custom form

Status
Not open for further replies.

Wigi

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Outlook.com (as MS Exchange)
Hi all, hi Diane,

I built an invoicing system based on my Outlook appointments. Each appointment is time spent on a certain customer and project.
A userform in Outlook shows all appointments of last month, say, and then a macro brings it to Excel with pivot tables and stuff to do the invoicing.
It all works pretty well :) I have a solid background in Excel VBA programming so Outlook VBA isn't difficult. My Outlook VBA code loops over appointments within a time range and collects information.

Now I want to take it 1 step further. For SLA kind of activities, I need to track more information. Like:
- a ticket reference (####) (free input, 4 digits)
- the name of the person logging a ticket (free input or combobox maybe)
- a certain ticket type (combobox with 4 options)
- was the ticket solved or not ?
- a description of the ticket and the solution (short free text)

Rather than using the Body of an appointment, I thought about using a Custom form. I played with that and while I can create these controls on 'P. 2', I am stuck. Is it the purpose to create such a new appointment class, fill in the controls, save the appointment and then the control contents STAY ?
I mean, I can use a combobox, save the custom appointment, reopen, and the combobox is empty again. I want to it be populated with my choices / selections.
Once I have entered 1 custom appointment, I would copy it for another ticket, change the contents and that's it.

My aim is to loop over appointment items, both standard and custom ones (i can do this, the class is different and I can distinguish both) and then read out the selections and textbox entries. I want to reopen the custom appointment at any time, make a change, and save. Early next month, retrieve all information from the appointments and build invoicing in Excel.

Or am I on the wrong track ? What websites/tutorials can you suggest in this area of custom forms for my application ?

Many thanks in advance ! I am an avid user of Excel but discovering many useful functionality of Outlook which makes life a lot easier !

Wim Gielis
Former MS Excel MVP (2010-2014)
 

Wigi

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Outlook.com (as MS Exchange)
I am making progress. I found out that I should use (custom) properties to bind the controls to.
I'll update the thread with newer information when I can.
 

Wigi

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Outlook.com (as MS Exchange)
A couple of hours later, I got it working ;-)
Excel tables get the information that is entered in textboxes and selected in listboxes.

The only thing that remains, is that my listbox values are hard-coded in the property to which I bind the value. I'll try to set the listbox items in code when the form opens.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Diane Poremsky Setting Custom Reminder Times New Slipstick.com Articles 0
S Setting up Outlook 2010 to work with custom domain outlook.com account BCM (Business Contact Manager) 3
S Question of setting the order of a custom menu in Outlook Outlook VBA and Custom Forms 1
P OWA Settings->Calendar->Events from Email; Setting changes do not hold Using Outlook 1
Marc2019 Setting up an Outlook Account on Mac Os 10.6.8 Outlook 2011 Using Outlook 1
L Outlook Office 365 client: won't remember my setting File, not to collapse ribbon Using Outlook 2
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
llama_thumper Setting up forwarders on Exchange server Exchange Server Administration 0
B Setting rules Using Outlook 1
C iCloud Setting missing Outlook tab and Outlook missing the iCloud refresh button Using Outlook 4
B Setting defaults Using Outlook 2
C need help setting up outlook first time Using Outlook 1
P Reading Pane (Reading Pain?) Default Setting Using Outlook 1
mctabish Setting "Reply To" based on inbox Outlook VBA and Custom Forms 2
R Setting font and color used when replying to an email Outlook VBA and Custom Forms 3
M Setting flag follow up for next business day Outlook VBA and Custom Forms 1
Ed Sheehan Unusual behaviour in setting Sender (Outlook 2016) Outlook VBA and Custom Forms 4
Jennifer Murphy Equations don't comply with style setting to left justify Using Outlook 0
J Setting default address book Using Outlook 0
N Does a Shared Folder Policy override a Digital Signature Setting for macros? Outlook VBA and Custom Forms 6
Diane Poremsky Setting up an Outlook.com IMAP account New Slipstick.com Articles 0
Diane Poremsky Setting the default Country for Outlook Contacts New Slipstick.com Articles 0
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
Diane Poremsky Adjusting Outlook's Zoom setting in Email New Slipstick.com Articles 0
O Setting default format for composing/replying to emails Using Outlook 3
B Outlook Calendar/setting appointments Using Outlook 1
Diane Poremsky Adjusting Outlook's Zoom setting in Email New Slipstick.com Articles 0
A Can't stop Outlook.com from setting reminders on appointments? Using Outlook.com accounts in Outlook 3
A Setting RULES with more than one condition in MS OUTLOOK Using Outlook 6
L Setting up my PA's Outlook Using Outlook 7
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
N "Instant Search" setting a default view Using Outlook 3
H SETTING UP A "NEW" NEVER HAD NEVER USED EMAIL ACCOUNT Using Outlook 9
K Setting Default Email Address for Meeting Replies Using Outlook 3
D Setting defult "Show a room list" Using Outlook 0
Horsepower Setting appointments in calendar Using Outlook 3
J Setting tabs in contacts / notes field Using Outlook 0
T Setting a Default Subject from a certain Signature Using Outlook 0
K Help Needed - setting up Email in Outlook 2013 Using Outlook 3
mikecox setting Default area code in Contacts Using Outlook 5
G Outlook2013 - "From" name doesn't change even when changed in Account Setting Using Outlook 4
D How do I start completely from scratch in setting up Outlook 2013? Using Outlook 6
V View zoom setting changing Using Outlook 1
C Setting up Outlook 10 on Widows 8 using Google Server Using Outlook 3
I Outlook Appointments - Setting default text in message body Using Outlook 3
T Setting Color codes for each user of a shared Calendar Using Outlook 1
J setting date in drafts Using Outlook 4
J Outlook 2010 - email address disappears when setting up new contact Using Outlook 0
V Setting up Outlook 2013 for AOL (POP3) Account Using Outlook 16
V Setting up windows 7 & outlook 2007 w/ Iphone 4 & synch contacts & calendar Using Outlook 9

Similar threads

Top