ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text following an Outlook field insertion (https://www.excelbanter.com/excel-programming/275257-text-following-outlook-field-insertion.html)

Shauna Koppang

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
.



All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com