Outlook has the contact is derived. XLS file function (now exported as template. XLS ), can import, of course, but if it is created by myself..xls files, but they could not import ( self-built. XLS ), self-built. XLS header is completely copy the template. XLS header, just template. XLS is outlook when export system is built, the self-built. XLS is in excle I create, I use the system is: win10 + outlook2010, in the template. XLS add, edit, delete or copy the files to other places will not affect the imported into the outlook, but self-built. XLS anyway can import, as if in the template. XLS add a watermark or other only Microsoft could identify,
Figure 1 for outlook export

Figure 2 to empty the outlook, can be imported into the outlook

Figure 3 is to create your own. XLS file header from template. XLS copy, but is unable to import to outlook,

Because I can't upload attachments, so the header cases for reference,
"English name", "name", "middle name", "name", "Chinese name", "unit", "department", _
"Position", "business address street", "business address street 2", "three business address street", "business address cities and counties", "business address provinces and autonomous regions", "business address zip code", "business address countries and regions," _
"Residential address street", "residential street address 2", "residential address street 3", "residential address cities and counties", "residential address provinces and autonomous regions," _
"Residential address zip code", "residential address country region", "other address street", "other address street 2", "3" other address street, _
"Other address cities and counties", "address of other provinces and autonomous regions", "other address postal code", "other countries address area", "assistant telephone," _
"Business fax", "business calls", "business calls 2", "call back", "car phone", "main phone unit", "residential fax", "home phone", _
"Home phone 2", "ISDN", "mobile phone", "other fax", "other phone", "pager", "main phone", "cordless phones," _
"TTYTDD phone", "telegraph", "Internet busy idle", "office", "location", "email address", "email type," _
"Email display name, email address 2", "email 2 type", "email 2 display name", "three email address", _
"Email 3 type", "three email display name", "note", "employee's card number", "key words", "accounting information", "anniversary," _
"The manager's name", "category", "miles", "sensitivity", "the directory server," "spouse", "other email address," "business email address," _
"Id number", "birthday", "private", "abbreviation", "page", "gender", "hobbies", "reference person", "user 1", _
"User 2", "user 3", 4 "user", "priority", "language", "account", "professional", "assistant's name", "residential address email", "children"

CodePudding user response:

Excel is 2010 version?

CodePudding user response:

In CSV format?

CodePudding user response:

This BBS do not directly upload attachment function,

At present CSDN resources are not "free", suggested that in the same way that a network location to share,
Method, 9/f, refer to this post: http://bbs.csdn.net/topics/392193811
If you have account in baidu, also can be directly with their own baidu network location to upload, share,

CodePudding user response:

I also met, the main reasons are the following several possible:
1. The problem of file formats: are XLS suffix, but there are plenty of HTML, have a plenty of office format;
2. The problem of cell attributes, each unit format has a label, may specifically defines the label, some joined the special format;
3. The Sheet name problem, the default is "sheet1", if you modify the cannot import;
4. The hidden problems, some table is hidden a column or a row, and even hide a certain table, so that you can not import,
.
So you can import to overhaul the form,