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

[Guest]

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?

 

[Sue Mosher [MVP-Outlook]]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

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

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Karl Timmermans]

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

 

[Guest]

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

 

[wis laughlin]

If all else fails, place this formula in a blank column to the left of the data containing "SMTP":

=LEFT(D5,FIND(" ",D5,1))

Then copy it and paste as a value.