Exported e-mail address has SMTP after address

T

tcdflash

When exporting contacts from Outlook to Excel the email address has SMTP
immediately following the address. i.e. (e-mail address removed). When I
try to send e-mails in a mail merge, Outlook will not send them because it
doesn't like the format. What can I do to avoid this problem? Thank you.
 
G

Gordon

tcdflash said:
When exporting contacts from Outlook to Excel the email address has SMTP
immediately following the address. i.e. (e-mail address removed). When
I
try to send e-mails in a mail merge, Outlook will not send them because it
doesn't like the format. What can I do to avoid this problem? Thank you.


Try doing a Find and Replace in Excel. Find smtp, replace with nothing.
 
T

tcdflash

Thank you Gordon, that worked!

Gordon said:
Try doing a Find and Replace in Excel. Find smtp, replace with nothing.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top