|
| 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. |
|
|||||||
| Tags: addresses, boxes |
|
|
Thread Tools | Display Modes |
|
#1
January 3rd 07, 06:41 PM
posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.outlook
|
|||
|
|||
Boxes in my addresses
Hi
i am inserting an address from outlook into excel by selecting the chossen address through a combobox. The address is all in one cell and has a box after each line. How do i get rid of the boxes? Thanks for any help in advance. 
|
| Ads |
|
#2
January 3rd 07, 06:53 PM
posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.outlook
|
|||
|
|||
|
Boxes in my addresses
"Oggy" wrote in message
ups.com... Hi i am inserting an address from outlook into excel by selecting the chossen address through a combobox. The address is all in one cell and has a box after each line. How do i get rid of the boxes? Thanks for any help in advance. this is really an Excel question not Outlook. Select the box, copy, and do a find and replace, replacing the box with nothing.
|
|
#3
January 3rd 07, 07:44 PM
posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.outlook
|
|||
|
|||
|
Boxes in my addresses
When the strings are concatenated into an Excel Cell using vbcrlf then the
strings do go into different lines but there appears a box at the end of the lines. Use vblf instead. Experiment by using the Immediate window to do the following Cells(1,1).value = "a" & vbcrlf & "b" Cells(1,1).value = "a" & vblf & "b" This might be the issue when you are moving the data into Excel. Alok "Oggy" wrote: Hi i am inserting an address from outlook into excel by selecting the chossen address through a combobox. The address is all in one cell and has a box after each line. How do i get rid of the boxes? Thanks for any help in advance.
|
|
#4
January 3rd 07, 09:01 PM
posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.outlook
|
|||
|
|||
|
Boxes in my addresses
Also see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legaul...4/08/4502.aspx -- 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 "Alok" wrote in message ... When the strings are concatenated into an Excel Cell using vbcrlf then the strings do go into different lines but there appears a box at the end of the lines. Use vblf instead. Experiment by using the Immediate window to do the following Cells(1,1).value = "a" & vbcrlf & "b" Cells(1,1).value = "a" & vblf & "b" This might be the issue when you are moving the data into Excel. Alok "Oggy" wrote: Hi i am inserting an address from outlook into excel by selecting the chossen address through a combobox. The address is all in one cell and has a box after each line. How do i get rid of the boxes? Thanks for any help in advance.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how do I set up separate mail boxes for different email addresses | revziggy | Outlook - General Queries | 1 | November 16th 06 05:37 PM |
| how do i view different mail boxes | btoonhoule | Outlook - General Queries | 1 | November 6th 06 11:00 PM |
| List Boxes | Motaad | Outlook - Using Forms | 7 | August 9th 06 01:30 AM |
| Different colors for drop down boxes | Angyl | Outlook - Using Forms | 1 | July 7th 06 12:33 AM |
| How to get email accounts in different boxes | eagletattoo | Outlook - General Queries | 4 | June 7th 06 09:26 AM |
Linear Mode
