A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Exporting e-dresses from contacts 2 Excel: how avoid SMTP suffix?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 11th 06, 03:35 AM posted to microsoft.public.outlook.contacts
John
external usenet poster
 
Posts: 382
Default Exporting 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?
  #2  
Old July 11th 06, 11:51 AM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Exporting e-dresses from contacts 2 Excel: how avoid SMTP suffix?

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"

--
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

"John" wrote in message ...
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?

  #3  
Old July 11th 06, 01:22 PM posted to microsoft.public.outlook.contacts
John
external usenet poster
 
Posts: 382
Default Exporting e-dresses from contacts 2 Excel: how avoid SMTP suff

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?)

"Sue Mosher [MVP-Outlook]" wrote:

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"

--
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

"John" wrote in message ...
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?


  #4  
Old July 11th 06, 01:30 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Exporting e-dresses from contacts 2 Excel: how avoid SMTP suff

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.

--
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

"John" wrote in message ...
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?)

"Sue Mosher [MVP-Outlook]" wrote:

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"

"John" wrote in message ...
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?


  #5  
Old July 12th 06, 08:21 PM posted to microsoft.public.outlook.contacts
John
external usenet poster
 
Posts: 382
Default Exporting e-dresses from contacts 2 Excel: how avoid SMTP suff

Sue, thanks. The Map Custom Fields option showed up in another attempt to
export. Thanks to your message, I quickly resolved the issue.

"Sue Mosher [MVP-Outlook]" wrote:

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.

--
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

"John" wrote in message ...
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?)

"Sue Mosher [MVP-Outlook]" wrote:

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"

"John" wrote in message ...
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?


  #6  
Old July 11th 06, 02:39 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default Exporting e-dresses from contacts 2 Excel: how avoid SMTP suffix?

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
--
__________________________________________________ ___________
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

"John" wrote in message
...
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?



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving the Categories in Contacts when Exporting to Excel Debbie Outlook - Using Contacts 1 June 14th 06 03:56 AM
Problem exporting contacts to excel [email protected] Outlook - Using Contacts 4 June 12th 06 08:36 AM
Exporting Contacts into Excel Anna Outlook - Using Contacts 4 June 1st 06 07:19 PM
Exporting contacts to Excel deaville Outlook Express 4 May 19th 06 11:36 PM
Exporting Contacts from Outlook emails don't go thru into Excel neilccarter Outlook - Using Contacts 1 January 18th 06 05:58 AM


All times are GMT +1. The time now is 10:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.