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