Problems with Emails and Lists in Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-2546604%22%20slang%3D%22en-US%22%3EProblems%20with%20Emails%20and%20Lists%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2546604%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20real%20issue%2C%20I%20just%20cannot%20solve.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20try%20to%20export%20a%20Microsoft%20Access%20Database%20to%20SharePoint.%20However%2C%20exporting%20is%20not%20possible%20because%20of%20Email%20addresses%20included%20in%20a%20table%20(the%20datatyp%20of%20the%20field%20is%20link).%20The%20error%20is%20always%3A%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%22Cannot%20send%20to%20server.%20The%20URL%20is%20either%20not%20valid%20or%20longer%20than%20255%20characters%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20directly%20enter%20an%20email%20address%20in%20sharepoint%2C%20I%20have%20no%20problem.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20appreciate%20any%20support%2C%20feedback%2C%20hint%2C%20as%20to%20how%20I%20can%20get%20my%20list%20of%20email%20adresses%20from%20MS%20Access%20to%20SharePoint.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks%3CBR%20%2F%3Emahu01%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2546604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597185%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20Emails%20and%20Lists%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597185%22%20slang%3D%22en-US%22%3EUnfortunately%2C%20I%20did%20not%20receive%20any%20replies.%20But%20I%20managed%20to%20find%20the%20problem%20(so%20I%20report%20it%20here%2C%20in%20case%20anybody%20else%20has%20the%20same%20problem)%3A%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20need%20to%20upload%20emails%20using%20%22Mailto%3A%22%20in%20front%20of%20any%20emails.%3CBR%20%2F%3E%3CBR%20%2F%3ETherefore%20the%20content%20of%20the%20attribute%20email%20should%20be%3A%3CBR%20%2F%3E%22Mailto%3A%20abc%40hotmail.com%22%3CBR%20%2F%3Eand%20not%3CBR%20%2F%3E%22abc%40hotmail.com%22%3CBR%20%2F%3E%3CBR%20%2F%3EOnce%20I%20changed%20all%20my%20email%20accordingly%2C%20upload%20went%20smooth.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%3CBR%20%2F%3Emahu01%3C%2FLINGO-BODY%3E
New Contributor

I have a real issue, I just cannot solve. 

 

I try to export a Microsoft Access Database to SharePoint. However, exporting is not possible because of Email addresses included in a table (the datatyp of the field is link). The error is always: 

"Cannot send to server. The URL is either not valid or longer than 255 characters". 

 

If I directly enter an email address in sharepoint, I have no problem. 

I would appreciate any support, feedback, hint, as to how I can get my list of email adresses from MS Access to SharePoint. 

Many thanks
mahu01

1 Reply
Unfortunately, I did not receive any replies. But I managed to find the problem (so I report it here, in case anybody else has the same problem):

You need to upload emails using "Mailto:" in front of any emails.

Therefore the content of the attribute email should be:
"Mailto: abc@hotmail.com"
and not
"abc@hotmail.com"

Once I changed all my email accordingly, upload went smooth.

Best
mahu01