View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shauna Koppang Shauna Koppang is offline
external usenet poster
 
Posts: 24
Default Text following an Outlook field insertion

Sheet1.Range("E13").Value = olCi.BusinessTelephoneNumber
& " Tel."

Hope this helps someone else. Sorry I am new to VB.

Shauna
-----Original Message-----
I am inserting a field from Outlook into a cell in my
worksheet and I want to also have it include the text

Tel.
after in the contents in the cell. Is this possible?

Sheet1.Range("E13").Value = olCi.BusinessTelephoneNumber

I would like a result something like:

(604) 684-5344 Tel.

Thanks!

Shauna
.