Insert Date From Form Into Subject Line

C

cvegas

I have downloaded an application that some one has written that allows me to
pull up an outlook 2 k task form from within Access 2k.

I would like to modify this so that when clicked information from my form
is inserted into the Subject line and also into the notes section.

IE: Subject Line = "Call" & " forms![ContactPopup]![ContactName] &
forms[[ContactPopup]![ContactPhone]

The results would look like

Subject: Call whoever 702-222-2222

Is this possible?

Case 6
Set objItem = spObj.CreateItem(olTaskItem)
objItem.Display
Set spObj = Nothing
Me.objOutlookFrame = Null
Exit Function
 
S

Sue Mosher [MVP]

You're already halfway there, since you've already created objItem. Before you display it, set its Subject property:

strSubject = "Call" & " forms![ContactPopup]![ContactName] & _
forms![ContactPopup]![ContactPhone]
objItem.Subject = strSubject
objItem.Body = strSubject

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top