Autofill subject line in appointment from options selected in combobox

Status
Not open for further replies.

cornetazo

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello,
I am looking to create a custom meeting invite in Outlook 2010 where the subject line only autofills based on the options selected from the dropdown in a combobox. I have 5 comboboxes and would like them to populate in the subject line in specific order. I know very little of VBScript so need all the help I can get.

Thanks.......
 
Thanks Diane but not exactly what I am looking for. I have created on (P.2) several options as shown below. Based on what is entered, I would like the Subject in the Appointment tab to autofill in this order: MK/V - Protocol # - Site # - PI Lastname - Visit ID.

Any help you can give is greatly appreciated.

Regards,
Luis
upload_2015-1-21_10-34-47.png
 
It worked!!

Thanks...You are a life saver. Last request, how can I insert hyphens (-) between [Part1], [Part2], [Part3], etc.?

I have tried several ways but keep getting errors when I run the form.
 
Sorry but also forgot to ask if there is a way to customize an appointment template by removing the "All day event" check box. Also, can I add a another field under the subject?

upload_2015-1-21_13-23-59.png
 
use & " - " & to add dashes or other hardcoded text -
[Part1] & " - " & [part 2]


the default page is not editable, so no, you can't remove all day checkbox or add a field. If you used form regions, you could do it, but form regions are harder to share with others.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M Autofill addresses Using Outlook 0
J Can't kill autofill email address Using Outlook 1
E Autofill Information in Email Template Using Outlook 2
H using VBA to edit subject line Outlook VBA and Custom Forms 0
F Auto changing email subject line in bulk Using Outlook 2
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
J Outlook 365 Forward Email Subject to my inbox when new email arrive in shared inbox Using Outlook 0
sjmo2 Change subject for new e-mails only. Outlook VBA and Custom Forms 2
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
D Prompt to prefix subject line whenever sending an email Outlook VBA and Custom Forms 3
ill13 Prepend the user's computer name to the subject. Outlook VBA and Custom Forms 1
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
2 How to get rid of the "Emailing:" prefix in the subject line Using Outlook 1
S Outlook Macro for [Date][Subject] Using Outlook 1
O How to find and replace a word in Outlook-Agenda-Subject and Message? Using Outlook 0
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
C Outlook 365 Subject Prefixes? Outlook VBA and Custom Forms 1
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
N Save selected messages VBA does not save replies and/or messages that contain : in subject Outlook VBA and Custom Forms 1
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
C How to rename subject line and forward the email Outlook VBA and Custom Forms 2
B Add Prefix text to Subject Line Using Outlook 1
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
M Outlook 2013 Replace Subject with Conversation (a "hidden" value). Outlook VBA and Custom Forms 0
M Convert Subject Line to Internet Header version of Subject Outlook VBA and Custom Forms 10
M Adding Subject to this Link-Saving VBA Outlook VBA and Custom Forms 5
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
B Remove Subject Residual Outlook VBA and Custom Forms 3
F VBA to ensure a code is entered in Subject title Outlook VBA and Custom Forms 1
A Check for words in subject header before sending email Outlook VBA and Custom Forms 4
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
M Adding Macro to populate "to" "subject" "body" not deleting email string below. Outlook VBA and Custom Forms 5
G Download pdf attachments only if email subject has one of words Outlook VBA and Custom Forms 8
C Change Subject Line in Selected Emails Outlook VBA and Custom Forms 1
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
D Edit Subject (Multiple Accounts) Outlook VBA and Custom Forms 5
E Outlook 2010 Subject sort uses Thread-Topic for grouping Using Outlook 2
C Outlook - cannot save subject line changes Using Outlook 2
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
E Search for folder by key in subject then move new message to related folder Outlook VBA and Custom Forms 1

Similar threads

Back
Top