SendToOutlook - Examples
You can copy and paste these examples, but be sure to adjust for your Quick Base field names.
SendToOutlook New Command - Quick Base Formula URLs
Email Message
This assumes a File Attachment field with a field id of 13 (i.e. "/e13" in the formula). Change to match your field, or remove that line entirely if you don't need attachments. Also assumes Quick Base field names of Email, Task Name and Task Description. Change to match your field names.
"SendToOutlook:New?ItemType=Email" &
"&Show=True" &
"&ContinueOnError=True" &
"&To=" & URLEncode([Email]) &
"&Subject=" & URLEncode([Task Name]) &
"&Body=" & URLEncode([Task Description]) &
"&Attachments=" & URLEncode(URLRoot() & "up/" &
Dbid() & "/a/r" & [Record ID#] & "/e13/v0")
Meeting (Calendar)
This assumes Quick Base field names of Email, Full Name, Phone, Start Date, and End Date. Change to match your field names.
"SendToOutlook:New?ItemType=Meeting" &
"&Show=True" &
"&ContinueOnError=True" &
"&To=" & URLEncode([Email]) &
"&Subject=Meet with " & URLEncode([Full Name]) &
"&Body=Voice: " & URLEncode([Phone]) &
"&Start=" & URLEncode([Start Date]) &
"&End=" & URLEncode([End Date]) &
"&TurnOffSendToQuickBase=True"
Contact
This assumes Quick Base field names of Name, Title, Phone, Email, Related Account, Address, City, State, Zip, Country, Account - Web, Mobile, Description, and Fax. Change to match your field names.
"SendToOutlook:New?ItemType=Contact" &
"&Show=True" &
"&ContinueOnError=True" &
"&Name=" & URLEncode([Name]) &
"&JobTitle=" & URLEncode([Title]) &
"&Phone=" & URLEncode([Phone]) &
"&Email1Address=" & URLEncode([Email]) &
"&Company=" & URLEncode([Related Account]) &
"&Street=" & URLEncode([Address]) &
"&City=" & URLEncode([City]) &
"&State=" & URLEncode([State]) &
"&PostalCode=" & URLEncode([Zip]) &
"&Country=" & URLEncode([Country]) &
"&WebPage=" & URLEncode([Account - Web]) &
"&Mobile=" & URLEncode([Mobile]) &
"&Body=" & URLEncode([Description]) &
"&Fax=" & URLEncode([Fax]) &
"&TurnOffSendToQuickBase=True"
SendToOutlook NewOrUpdate Command - Quick Base Formula URLs
Contact
This assumes Quick Base field names of Name, Title, Phone, Email, Related Account, Address, City, State, Zip, Country, Account - Web, Mobile, Description, and Fax. Change to match your field names. This URL is identical to the one above, with the addition of AppId, TableID and RecordID
"SendToOutlook:NewOrUpdate?ItemType=Contact" &
"&Show=True" &
"&ContinueOnError=True" &
"&Name=" & URLEncode([Name]) &
"&JobTitle=" & URLEncode([Title]) &
"&Phone=" & URLEncode([Phone]) &
"&Email1Address=" & URLEncode([Email]) &
"&Company=" & URLEncode([Related Account]) &
"&Street=" & URLEncode([Address]) &
"&City=" & URLEncode([City]) &
"&State=" & URLEncode([State]) &
"&PostalCode=" & URLEncode([Zip]) &
"&Country=" & URLEncode([Country]) &
"&WebPage=" & URLEncode([Account - Web]) &
"&Mobile=" & URLEncode([Mobile]) &
"&Body=" & URLEncode([Description]) &
"&Fax=" & URLEncode([Fax]) &
"&TurnOffSendToQuickBase=True" &
"&AppId=" & AppId() &
"&TableId=" & Dbid() &
"&RecordId=" & [Record ID#]
SendToOutlook Open Command - Quick Base Formula URLs
Contact (Using AppId, TableId, RecordId)
"SendToOutlook:Open?ItemType=Contact" &
"&AppId=" & AppId() &
"&TableId=" & Dbid() &
"&RecordId=" & [Record ID#]
Contact (Using EntryID)
"SendToOutlook:Open?EntryID=" & URLEncode([EntryID])
SendToOutlook New Command - Other URLs (not for Quick Base)
Note: In the examples below, the "Click here to create the ..." links will only work properly if SendToOutlook has been installed.
The links below are wrapped across lines, but must be a single line when used.
Create a Meeting
Click here to create the Meeting.
SendToOutlook:New?ItemType=Meeting
&Show=True
&To=joe@example.com;mary@example.com
&Subject=Discuss Pricing
&Location=Phone Call
&Start=5/13/2009 9:00 AM
&End=5/13/2009 10:00 AM
&ReminderMinutesBeforeStart=30
&Body=We must discuss the new pricing discounts.
Create an Appointment
Click here to create the Appointment.
(same as Meeting, just no To because no invitees)
SendToOutlook:New?ItemType=Appointment
&Show=True
&Subject=Discuss Pricing
&Location=Phone Call
&Start=5/13/2009 9:00 AM
&End=5/13/2009 10:00 AM
&ReminderMinutesBeforeStart=30
Create a Task
Click here to create the Task.
Note: The Priority value is set using the Importance Outlook field.
SendToOutlook:New?ItemType=Task
&Show=True
&Subject=Review Specification %26 Approve
&Show=True
&To=joe@example.com
&Body=Review and approve specification
&StartDate=5/13/2009 10:00 AM
&DueDate=5/15/2009 3:00 PM
&Importance=High
&TotalWork=60
Create a Contact
Click here to create the Contact.
SendToOutlook:New?ItemType=Contact
&Show=True
&FirstName=Joe
&LastName=Acunzo
&JobTitle=Founder
&BusinessTelephoneNumber=203-481-1222 ext. 316
&Email1Address=joe@example.com
&CompanyName=SoftTechExperts
&BusinessAddressStreet=500 E. Main St. Suite 216
&BusinessAddressCity=Branford
&BusinessAddressState=CT
&BusinessAddressPostalCode=06405
&WebPage=www.SoftTechExperts.com
Create an Email Message
Click here to create the Email Message.
SendToOutlook:New?ItemType=Email
&Show=True
&To=joe@example.com;mary@example.com
&CC=sally@example.com
&Subject=Updated Pricing
&Body=There is a new price list for this year. Call me for details!
Create a Note
Click here to create the Note.
Note: Below, %0A is the encoding for a new line.
SendToOutlook:New?ItemType=Note
&Show=True
&Color=Blue
&Body=Company Holidays: %0A New Years Day %0A 4th of July %0A Christmas Day