|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
October 10th 06, 01:12 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Combining fields and new line
I want to make a new field in my Oulook Contact form which holds the full
person's name and address. I have found how I can combine the fields, but can't find how to display them each on a new line. I've got: [Company] [Full name] [Address] and it should display as: [Company] [Full name] [Address] In Word I would use ^p and in VBA it would be vbCr or vbCrLf. What do I use here? 
|
|
#2
October 10th 06, 01:22 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Combining fields and new line
Use a formula field, not a combination field, and a formula like this:
[Company] & Chr(13) & Chr(10) & [Full Name] & Chr(13) & Chr(10) & [Business Address] -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "BartH_NL" wrote in message ... I want to make a new field in my Oulook Contact form which holds the full person's name and address. I have found how I can combine the fields, but can't find how to display them each on a new line. I've got: [Company] [Full name] [Address] and it should display as: [Company] [Full name] [Address] In Word I would use ^p and in VBA it would be vbCr or vbCrLf. What do I use here?
|
|
#3
October 10th 06, 01:57 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Combining fields and new line
Sue, you are priceless! Have a hughe bunch of flowers.
"Sue Mosher [MVP-Outlook]" wrote: Use a formula field, not a combination field, and a formula like this: [Company] & Chr(13) & Chr(10) & [Full Name] & Chr(13) & Chr(10) & [Business Address] -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "BartH_NL" wrote in message ... I want to make a new field in my Oulook Contact form which holds the full person's name and address. I have found how I can combine the fields, but can't find how to display them each on a new line. I've got: [Company] [Full name] [Address] and it should display as: [Company] [Full name] [Address] In Word I would use ^p and in VBA it would be vbCr or vbCrLf. What do I use here?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Nesting or combining distribution lists | Judy | Outlook - Using Contacts | 4 | August 22nd 06 11:22 PM |
| Combining calendars (and taking them apart again | MBW | Outlook - Calandaring | 3 | June 20th 06 03:44 AM |
| Combining Text and Date | srm | Outlook - Using Forms | 0 | June 19th 06 08:01 PM |
| Combining Distribution Lists | trpit | Outlook - Using Contacts | 5 | May 31st 06 04:24 AM |
| Mail merge Contacts fields into subject line of email | TheScenicRoute | Outlook - Using Contacts | 5 | April 14th 06 03:02 PM |
Hybrid Mode
