I have exported my contact list to excel, updated some of the contacts and then added further contacts.

When I have Imported the list back, each of the email addresses have an added text at the end (%SMTP%).

i.e. john.smith@gmail.com %SMTP%

This is preventing the email from sending.

Any idea why it is adding this and what I can do to stop it happening?

Thanks

Hi,

Based on my research, the reason would be because of the field mapping used on import. "SMTP" is the Email address Type which is added automatically for SMTP type addresses (when a value is mapped to the Email AddressfField).  

So try to copy the pst file to get the contacts.

To export from Outlook, you can try this free tool download CodeTwo Outlook Export

For import, you can in excel add namesapace for range and import new address list.

Dim oName As Name

For Each oName In ActiveWorkbook.Names
If len(oName.Name)> 0 Then oName.Delete
Next
ActiveWorkbook.Names.Add Name:=Contacts, _
RefersTo:=Range(A1:J & Cells(Rows.Count, A).End(xlUp).Row)

'column in refers you should fit do data

A was written about that there (I'm showing Tasks - but this solve the same problem)

regards