C
cvegas
I have this working but would like to display the [BusinessPhone] in a
standard format like
(800)888-8888
Set objItem = spObj.CreateItem(olTaskItem)
strSubject = "Call " & Forms![Prospect Contact Popup Form For All
Contacts]![FirstName] & _
" " & Forms![Prospect Contact Popup Form For All
Contacts]![BusinessPhone] & " about " & _
Forms![Prospect Contact Popup Form For All Contacts]![ShowName]
Any help would be appreciated.
standard format like
(800)888-8888
Set objItem = spObj.CreateItem(olTaskItem)
strSubject = "Call " & Forms![Prospect Contact Popup Form For All
Contacts]![FirstName] & _
" " & Forms![Prospect Contact Popup Form For All
Contacts]![BusinessPhone] & " about " & _
Forms![Prospect Contact Popup Form For All Contacts]![ShowName]
Any help would be appreciated.