 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / November 2007Outlook 2007 Copy/Paste address information problems
I don't seem to be able to get the different parts of the address to go into the intended fields if I just copy an address, say from a 411.com listing directly into a contact. The information looks right but if I click on the address button to open the check address dialog most of the info are in the wrong fields. Also I have my location in regional and laguage options set to Canada but always end up with the county/region as US. Does anyone know the rules (commas / spaces or whatever) to match the data to the right fields and how to set the country? Provide clearer information, please. "Just copy an address directly into a Contact" tells us nothing. That could mean anything. Parse the address elements yourself. Clarify how you set your location and in what operating system.  SignatureRuss Valentine [MVP-Outlook] >I don't seem to be able to get the different parts of the address to go >into [quoted text clipped - 9 lines] > how > to set the country? Hello Russ, I guess that didn't mean much by itself, but I thought it would be understood with the rest of the info and the actual question. I guess the best way to explain is with a short video clip. It's about 3.6 MBs http://www.favron.com/images/posted/outlookaddr.avi > Provide clearer information, please. "Just copy an address directly into a > Contact" tells us nothing. That could mean anything. Parse the address [quoted text clipped - 13 lines] > > how > > to set the country? So you're copying and pasting from a Web page into a derived field? That will have mixed results at best depending on the HTML code. As I said, I'd parse the address elements yourself. SignatureRuss Valentine [MVP-Outlook] > Hello Russ, > [quoted text clipped - 24 lines] >> > how >> > to set the country? OK that's fine but does anyone know the rules for parsing or where I could look them up? That was really my (perhaps mistated) question if you refer to the last sentence of my original post. > So you're copying and pasting from a Web page into a derived field? That > will have mixed results at best depending on the HTML code. [quoted text clipped - 27 lines] > >> > how > >> > to set the country? What do you mean by "rules for parsing?" There are no rules. Place the individual address elements into their respective fields. Outlook cannot parse address information by itself when you place HTML code into a derived field. SignatureRuss Valentine [MVP-Outlook] > OK that's fine but does anyone know the rules for parsing or where I could > look them up? That was really my (perhaps mistated) question if you refer [quoted text clipped - 40 lines] >> >> > how >> >> > to set the country? Hello Russ. I’m not sure I can follow the ”There are no rules” idea. This idea “Outlook cannot parse address information by itself when…” seems to be a rule, one of those rules I’m trying to understand. Anyway clearly Outlook is consistent in how it formats an address. It has never simply put all of the information in the first field. To me, there is some “logic” that is being done to determine which info goes in which field so I continued testing. I took that same address from that same website and copied it to a text document first so now all that was left was plain text. I copied it from there and still the exact same placement of text within the address fields... Anyway after lots of testing, I noticed that I could copy/paste that address directly from the website to the address in the contact if I added the country to it after (well, specifically a CR and then the country). That address only worked when the country was Canada, not United States of America, so I guess the logic for zip codes (being all numbers in the US instead of letter/number/letter/space/number/letter/number in Canada made the difference. I made a new clip in case my babbling on is confusing to anyone. This one is a bit smaller. http://www.favron.com/images/posted/outlookaddr2.avi I noticed a few other things with the formatting behavior; If there are no CRs (address all on one line) the address starts in the city field. If there are multiple CRs, all except what comes after the last one will be in the street address field. I guess I answered my own questions about the formatting but I hope that helps anyone else. I guess it’s less of a problem in the US since the default country is the US. My last question is does anyone know how to make Canada the default country (for a new Outlook contact)? > What do you mean by "rules for parsing?" There are no rules. Place the > individual address elements into their respective fields. Outlook cannot [quoted text clipped - 44 lines] > >> >> > how > >> >> > to set the country? It has never been a good idea to paste address information into a derived field like the address block. When you do so, you force Outlook to parse the data instead of doing it yourself. Outlook may or may not get it right. You will. Outlook relies on your operating system settings to set your default country. State how you set that. SignatureRuss Valentine [MVP-Outlook] > Hello Russ. > I’m not sure I can follow the ”There are no rules” idea. This idea [quoted text clipped - 99 lines] >> >> >> > how >> >> >> > to set the country? Well, it shouldn't be a big deal for Outlook's address block to parse address information. I've got no problem "forcing" Outlook to do it. I rather think of "doing it myself" as the instead part, as in instead of letting Outlook do it for me. Anyway I'm pretty sure I understand how to make sure Outlook gets it right now. I expected Outlook to use the OS setting since I couldn't find any option in Outlook (but I could be wrong) so that's where I looked to make sure I had it set to Canada as I mentioned, in the regional and language options as my location. > It has never been a good idea to paste address information into a derived > field like the address block. When you do so, you force Outlook to parse the [quoted text clipped - 106 lines] > >> >> >> > how > >> >> >> > to set the country? Can't repro your problem. I don't see where you answered my question. SignatureRuss Valentine [MVP-Outlook] > Well, it shouldn't be a big deal for Outlook's address block to parse > address [quoted text clipped - 143 lines] >> >> >> >> > how >> >> >> >> > to set the country? I assumed you you know that regional and language options is a control panel module. In XP the bottom of the first tab (regional options) is the location box. I set it to Canada. Since you can't reproduce the problem I expect I just have some kind of registry corruption and I'll leave it at that. For the little inconvenience it might cause me I don't think it's worth spending any debugging time on it. > Can't repro your problem. I don't see where you answered my question. > > Well, it shouldn't be a big deal for Outlook's address block to parse [quoted text clipped - 144 lines] > >> >> >> >> > how > >> >> >> >> > to set the country? You assumed too much. You hadn't even specified your OS, so I could I have been sure you had made your settings correctly? You should also check to be sure you have your default dialing location set correctly because Outlook will often use that to determine your location. SignatureRuss Valentine [MVP-Outlook] >I assumed you you know that regional and language options is a control >panel [quoted text clipped - 184 lines] >> >> >> >> >> > how >> >> >> >> >> > to set the country? Hi Russ, Sorry, I figured that because Office 2007 OS compatibility starts with XP SP2 and that the videos I made would have looked different on Vista, and with some other anecdotal information such as I called the settings regional and language options, people who could help would instinctively know I was using XP. I wish you wouldn’t have said hadn’t “even” specified though because to me that indicates a level of frustration. I apologize for any I caused, I appreciate your helpful help and timely answers. I also checked my phone and modem options and the country/region for my location was already Canada as well. Thanks for the suggestion. I decided to try uniblue registrybooster which corrected many (registry) errors and now when I click that address block button instead of the country already being filled in with United States of America the country field is blank. I took that as an improvement (as a technical matter, no offence to any US citizen) and tried that same Canadian address again from that webpage and it worked! All the info was placed in the right fields and it filled in Canada as the country :) > You assumed too much. You hadn't even specified your OS, so I could I have > been sure you had made your settings correctly? You should also check to be [quoted text clipped - 188 lines] > >> >> >> >> >> > how > >> >> >> >> >> > to set the country? Cool. I wonder how "registrybooster" knew what to fix? I've never been brave enough to try utilities like that. I wonder how your location setting became corrupt in the first place. That's what I suspected which is why I wanted the details on how you had set it in the first place. I've not seen this reported before, but it's a good one to add to the list, especially if you can think of any of the steps to repro the problem in the fist place. BTW, the default behavior for inserting an address from Outlook in Word should be to omit the country unless it is different from the local setting. So it sounds like it is now behaving as expected since you fixed your registry setting. SignatureRuss Valentine [MVP-Outlook] > Hi Russ, > [quoted text clipped - 253 lines] >> >> >> >> >> >> > how >> >> >> >> >> >> > to set the country? I wouldn't have tried it either but they are a Microsoft Certified Partner and my research on them only turned up positive stuff. It found and fixed 1054 errors actually and my laptop is booting/shutting down/running very noticably faster. I recommend them, at least for that program. As a bonus it backsup the registry (better than system restore) and it defrags the registry. The last time I tried to defrag the registry was with a norton program and it made things worse. This time it was an improvement. > Cool. I wonder how "registrybooster" knew what to fix? I've never been brave > enough to try utilities like that. I wonder how your location setting became [quoted text clipped - 242 lines] > >> >> >> >> >> >> > the > >> >> >> >> >> >> > address button to open the check address dialog most of Still wish I knew how your location settings got corrupted in the first place. SignatureRuss Valentine [MVP-Outlook] >I wouldn't have tried it either but they are a Microsoft Certified Partner > and my research on them only turned up positive stuff. It found and fixed [quoted text clipped - 301 lines] >> >> >> >> >> >> >> > address button to open the check address dialog most >> >> >> >> >> >> >> > of |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.