 |
 | 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 / July 2006Exporting e-dresses from contacts 2 Excel: how avoid SMTP suffix?
My e-mail addresses are showing up (for the first time) in Excel with an added SMTP suffix that makes them unusable. How can I keep the e-mail address pure? Three things might help generate an answer to your issue: 1) Your version of Outlook 2) What steps you took to export 3) An explanation of what you mean by "an added SMTP suffix"  SignatureSue 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 > My e-mail addresses are showing up (for the first time) in Excel with an > added SMTP suffix that makes them unusable. How can I keep the e-mail > address pure? Outlook and Excel are both 2003. My technique in exporting has worked properly before. What is happening now is that Contacts is exporting to columns in Excel that use the first word to identify where to place info. Because "E-mail", "E-mail Type" and "E-mail Display Name" all start the same, the information is being lumped together in one column. What has caused this change - and more to the point, how can I prevent it (e.g. return to the former distinction in where Excel puts the info?) > Three things might help generate an answer to your issue: > [quoted text clipped - 5 lines] > > added SMTP suffix that makes them unusable. How can I keep the e-mail > > address pure? That doesn't answer question #2 or #3. In particular, you didn't say anything about how you're handling the Map Custom Fields option. SignatureSue 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 > Outlook and Excel are both 2003. My technique in exporting has worked > properly before. What is happening now is that Contacts is exporting to [quoted text clipped - 13 lines] >> > added SMTP suffix that makes them unusable. How can I keep the e-mail >> > address pure? Sue, thanks. The Map Custom Fields option showed up in another attempt to export. Thanks to your message, I quickly resolved the issue. > That doesn't answer question #2 or #3. In particular, you didn't say anything about how you're handling the Map Custom Fields option. > [quoted text clipped - 15 lines] > >> > added SMTP suffix that makes them unusable. How can I keep the e-mail > >> > address pure? You are likely just selecting the wrong email field in your field map. You'll notice that there are 3 email field (Email, Email 2, Email 3) each of which have a + sign beside them that will expand to 3 other field choices. Select the field marked "Email Address" and that will only export the email address without adding the Email Type (i.e. SMTP) & DisplayAs information. Karl Signature_____________________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2003" http://www.contactgenie.com > My e-mail addresses are showing up (for the first time) in Excel with an > added SMTP suffix that makes them unusable. How can I keep the e-mail > address pure? |
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.