ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 Excel Home精品图文教程库
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
300集Office 2010微视频教程 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
12
返回列表 发新帖
楼主: ldy

[分享] EXCEL通讯录 导入手机联系人

[复制链接]

TA的精华主题

TA的得分主题

发表于 2019-10-2 14:07 | 显示全部楼层
本帖已被收录到知识树中,索引项:模板和开源系统
下载学习的好机会

TA的精华主题

TA的得分主题

发表于 2022-6-5 17:35 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
苹果手机的联系人,全部字段:
BEGIN:VCARD
VERSION:3.0
PRODID:-//Apple Inc.//iOS 8.1.1//EN
N:Contact;Full;Middle;Dr.;Suffix
FN:Dr. Full Middle Contact Suffix
NICKNAME:Pseudo
NOTE:My note
X-PHONETIC-FIRST-NAME:Phonetic First Name
X-PHONETIC-MIDDLE-NAME:Phonetic Middle Name
X-PHONETIC-LAST-NAME:Phonetic Last Name
ORG:SuperCorp;Department
TITLE:Chairman
EMAIL;type=INTERNET;type=HOME;type=pref:test@cozy.io
EMAIL;type=INTERNET;type=WORK:test2@cozy.io
item1.EMAIL;type=INTERNET:test3@cozy.io
item1.X-ABLabel:iCloud
item2.EMAIL;type=INTERNET:test4@cozy.io
item2.X-ABLabel:_$!<Other>!$_
item3.EMAIL;type=INTERNET:test5@cozy.io
item3.X-ABLabel:Customemail
EMAIL;type=INTERNET;type=HOME:gelnior@free.fr
TEL;type=HOME;type=VOICE;type=pref:0102030400
TEL;type=WORK;type=VOICE:0102030401
TEL;type=IPHONE;type=CELL;type=VOICE:0102030402
TEL;type=CELL;type=VOICE:0102030403
TEL;type=MAIN:010203040Nickname4
TEL;type=HOME;type=FAX:0102030405
TEL;type=WORK;type=FAX:0102030406
TEL;type=PAGER:0102030407
TEL;type=OTHER;type=VOICE:0102030408
item4.TEL:0102030409
item4.X-ABLabel:Customphone
TEL;type=HOME;type=VOICE:0867&#160;45346
item5.ADR;type=HOME;type=pref:;;52\nRue Bonsergent;Paris;Ile De France;75010;France
item5.X-ABADR:fr
item6.ADR;type=WORK:;;53\nRue Bonsergent;Paris;Ile De France;75010;France
item6.X-ABADR:fr
item7.ADR;type=OTHER:;;54\nRue Bonsergent;Paris;Ile De France;75010;France
item7.X-ABADR:fr
item8.ADR;type=HOME:;;55\nRue Bonsergent;75010;Ile De France;Paris;France
item8.X-ABLabel:Customaddress
item8.X-ABADR:fr
item9.URL;type=pref:http://homepage.fr
item9.X-ABLabel:_$!<HomePage>!$_
URL;type=HOME:http://home.fr
URL;type=WORK:http://work.fr
item10.URL:http://other.fr
item10.X-ABLabel:_$!<Other>!$_
item11.URL:http://custom.fr
item11.X-ABLabel:Custom
BDAY;value=date:2015-03-03
item12.X-MSN:msn
item12.X-ABLabel:MSN
item13.X-AIM:aim
item13.X-ABLabel:AIM
item14.X-YAHOO:yahoo
item14.X-ABLabel:Yahoo
item15.X-ICQ:icq
item15.X-ABLabel:ICQ
item16.X-JABBER:jabber
item16.X-ABLabel:Jabber
item17.IMPP;X-SERVICE-TYPE=Skype;type=pref:skype:skype
item17.X-ABLabel:Skype
item18.IMPP;X-SERVICE-TYPE=MSN:msnim:msn
item18.X-ABLabel:MSN
item19.IMPP;X-SERVICE-TYPE=GoogleTalk:xmpp:gtalk
item19.X-ABLabel:GoogleTalk
item20.IMPP;X-SERVICE-TYPE=Facebook:xmpp:facebook
item20.X-ABLabel:Facebook
item21.IMPP;X-SERVICE-TYPE=AIM:aim:aim
item21.X-ABLabel:AIM
item22.IMPP;X-SERVICE-TYPE=Yahoo:ymsgr:yahoo
item22.X-ABLabel:Yahoo
item23.IMPP;X-SERVICE-TYPE=ICQ:aim:icq
item23.X-ABLabel:ICQ
item24.IMPP;X-SERVICE-TYPE=Jabber:xmpp:jabber
item24.X-ABLabel:Jabber
item25.IMPP;X-SERVICE-TYPE=QQ:x-apple:qq
item25.X-ABLabel:QQ
item26.IMPP;X-SERVICE-TYPE=GaduGadu:x-apple:gad
item26.X-ABLabel:GaduGadu
item27.IMPP;X-SERVICE-TYPE=Customim:x-apple:custom%20im
item27.X-ABLabel:Skype
X-SOCIALPROFILE;type=twitter;x-user=twitteruser:http://twitter.com/twitteruser
X-SOCIALPROFILE;type=facebook;x-user=facebookuser:http://www.facebook.com/facebookuser
X-SOCIALPROFILE;type=flickr;x-user=flickruser:http://www.flickr.com/photos/flickruser
X-SOCIALPROFILE;type=linkedin;x-user=linkedinuser:http://www.linkedin.com/in/linkedinuser
X-SOCIALPROFILE;type=myspace;x-user=myspaceuser:http://www.myspace.com/myspaceuser
X-SOCIALPROFILE;type=sinaweibo;x-user=sinauser:http://weibo.com/n/sinauser
X-SOCIALPROFILE;type=Customsocial;x-user=custom socialuser:x-apple:custom%20socialuser
item28.X-ABDATE;type=pref:2013-03-12
item28.X-ABLabel:_$!<Anniversary>!$_
item29.X-ABDATE:2012-03-12
item29.X-ABLabel:_$!<Other>!$_
item30.X-ABDATE:2006-03-12
item30.X-ABLabel:Customdate
item31.X-ABRELATEDNAMES;type=pref:Mother
item31.X-ABLabel:_$!<Mother>!$_
item32.X-ABRELATEDNAMES:Father
item32.X-ABLabel:_$!<Father>!$_
item33.X-ABRELATEDNAMES:Parent
item33.X-ABLabel:_$!<Parent>!$_
item34.X-ABRELATEDNAMES:Brother
item34.X-ABLabel:_$!<Brother>!$_
item35.X-ABRELATEDNAMES:Sister
item35.X-ABLabel:_$!<Sister>!$_
item36.X-ABRELATEDNAMES:Child
item36.X-ABLabel:_$!<Child>!$_
item37.X-ABRELATEDNAMES:Friend
item37.X-ABLabel:_$!<Friend>!$_
item38.X-ABRELATEDNAMES:Spouse
item38.X-ABLabel:_$!<Spouse>!$_
item39.X-ABRELATEDNAMES:Partner
item39.X-ABLabel:_$!<Partner>!$_
item40.X-ABRELATEDNAMES:Assistant
item40.X-ABLabel:_$!<Assistant>!$_
item41.X-ABRELATEDNAMES:Manager
item41.X-ABLabel:_$!<Manager>!$_
item42.X-ABRELATEDNAMES:Other
item42.X-ABLabel:_$!<Other>!$_
item43.X-ABRELATEDNAMES:Custom Relation
item43.X-ABLabel:Customrelation
X-ACTIVITY-ALERT:type=call\,snd=system:Bulletin\,vib=Alert
X-ACTIVITY-ALERT:type=text\,snd=<none>
X-ALTBDAY;CALSCALE=chinese:007800301201
END:VCARDBEGIN:VCARD
VERSION:3.0
PRODID:-//Apple Inc.//iOS 8.1.1//EN
N:Contact;Full;Middle;Dr.;Suffix
FN:Dr. Full Middle Contact Suffix
NICKNAME:Pseudo
NOTE:My note
X-PHONETIC-FIRST-NAME:Phonetic First Name
X-PHONETIC-MIDDLE-NAME:Phonetic Middle Name
X-PHONETIC-LAST-NAME:Phonetic Last Name
ORG:SuperCorp;Department
TITLE:Chairman
EMAIL;type=INTERNET;type=HOME;type=pref:test@cozy.io
EMAIL;type=INTERNET;type=WORK:test2@cozy.io
item1.EMAIL;type=INTERNET:test3@cozy.io
item1.X-ABLabel:iCloud
item2.EMAIL;type=INTERNET:test4@cozy.io
item2.X-ABLabel:_$!<Other>!$_
item3.EMAIL;type=INTERNET:test5@cozy.io
item3.X-ABLabel:Customemail
EMAIL;type=INTERNET;type=HOME:gelnior@free.fr
TEL;type=HOME;type=VOICE;type=pref:0102030400
TEL;type=WORK;type=VOICE:0102030401
TEL;type=IPHONE;type=CELL;type=VOICE:0102030402
TEL;type=CELL;type=VOICE:0102030403
TEL;type=MAIN:010203040Nickname4
TEL;type=HOME;type=FAX:0102030405
TEL;type=WORK;type=FAX:0102030406
TEL;type=PAGER:0102030407
TEL;type=OTHER;type=VOICE:0102030408
item4.TEL:0102030409
item4.X-ABLabel:Customphone
TEL;type=HOME;type=VOICE:0867&#160;45346
item5.ADR;type=HOME;type=pref:;;52\nRue Bonsergent;Paris;Ile De France;75010;France
item5.X-ABADR:fr
item6.ADR;type=WORK:;;53\nRue Bonsergent;Paris;Ile De France;75010;France
item6.X-ABADR:fr
item7.ADR;type=OTHER:;;54\nRue Bonsergent;Paris;Ile De France;75010;France
item7.X-ABADR:fr
item8.ADR;type=HOME:;;55\nRue Bonsergent;75010;Ile De France;Paris;France
item8.X-ABLabel:Customaddress
item8.X-ABADR:fr
item9.URL;type=pref:http://homepage.fr
item9.X-ABLabel:_$!<HomePage>!$_
URL;type=HOME:http://home.fr
URL;type=WORK:http://work.fr
item10.URL:http://other.fr
item10.X-ABLabel:_$!<Other>!$_
item11.URL:http://custom.fr
item11.X-ABLabel:Custom
BDAY;value=date:2015-03-03
item12.X-MSN:msn
item12.X-ABLabel:MSN
item13.X-AIM:aim
item13.X-ABLabel:AIM
item14.X-YAHOO:yahoo
item14.X-ABLabel:Yahoo
item15.X-ICQ:icq
item15.X-ABLabel:ICQ
item16.X-JABBER:jabber
item16.X-ABLabel:Jabber
item17.IMPP;X-SERVICE-TYPE=Skype;type=pref:skype:skype
item17.X-ABLabel:Skype
item18.IMPP;X-SERVICE-TYPE=MSN:msnim:msn
item18.X-ABLabel:MSN
item19.IMPP;X-SERVICE-TYPE=GoogleTalk:xmpp:gtalk
item19.X-ABLabel:GoogleTalk
item20.IMPP;X-SERVICE-TYPE=Facebook:xmpp:facebook
item20.X-ABLabel:Facebook
item21.IMPP;X-SERVICE-TYPE=AIM:aim:aim
item21.X-ABLabel:AIM
item22.IMPP;X-SERVICE-TYPE=Yahoo:ymsgr:yahoo
item22.X-ABLabel:Yahoo
item23.IMPP;X-SERVICE-TYPE=ICQ:aim:icq
item23.X-ABLabel:ICQ
item24.IMPP;X-SERVICE-TYPE=Jabber:xmpp:jabber
item24.X-ABLabel:Jabber
item25.IMPP;X-SERVICE-TYPE=QQ:x-apple:qq
item25.X-ABLabel:QQ
item26.IMPP;X-SERVICE-TYPE=GaduGadu:x-apple:gad
item26.X-ABLabel:GaduGadu
item27.IMPP;X-SERVICE-TYPE=Customim:x-apple:custom%20im
item27.X-ABLabel:Skype
X-SOCIALPROFILE;type=twitter;x-user=twitteruser:http://twitter.com/twitteruser
X-SOCIALPROFILE;type=facebook;x-user=facebookuser:http://www.facebook.com/facebookuser
X-SOCIALPROFILE;type=flickr;x-user=flickruser:http://www.flickr.com/photos/flickruser
X-SOCIALPROFILE;type=linkedin;x-user=linkedinuser:http://www.linkedin.com/in/linkedinuser
X-SOCIALPROFILE;type=myspace;x-user=myspaceuser:http://www.myspace.com/myspaceuser
X-SOCIALPROFILE;type=sinaweibo;x-user=sinauser:http://weibo.com/n/sinauser
X-SOCIALPROFILE;type=Customsocial;x-user=custom socialuser:x-apple:custom%20socialuser
item28.X-ABDATE;type=pref:2013-03-12
item28.X-ABLabel:_$!<Anniversary>!$_
item29.X-ABDATE:2012-03-12
item29.X-ABLabel:_$!<Other>!$_
item30.X-ABDATE:2006-03-12
item30.X-ABLabel:Customdate
item31.X-ABRELATEDNAMES;type=pref:Mother
item31.X-ABLabel:_$!<Mother>!$_
item32.X-ABRELATEDNAMES:Father
item32.X-ABLabel:_$!<Father>!$_
item33.X-ABRELATEDNAMES:Parent
item33.X-ABLabel:_$!<Parent>!$_
item34.X-ABRELATEDNAMES:Brother
item34.X-ABLabel:_$!<Brother>!$_
item35.X-ABRELATEDNAMES:Sister
item35.X-ABLabel:_$!<Sister>!$_
item36.X-ABRELATEDNAMES:Child
item36.X-ABLabel:_$!<Child>!$_
item37.X-ABRELATEDNAMES:Friend
item37.X-ABLabel:_$!<Friend>!$_
item38.X-ABRELATEDNAMES:Spouse
item38.X-ABLabel:_$!<Spouse>!$_
item39.X-ABRELATEDNAMES:Partner
item39.X-ABLabel:_$!<Partner>!$_
item40.X-ABRELATEDNAMES:Assistant
item40.X-ABLabel:_$!<Assistant>!$_
item41.X-ABRELATEDNAMES:Manager
item41.X-ABLabel:_$!<Manager>!$_
item42.X-ABRELATEDNAMES:Other
item42.X-ABLabel:_$!<Other>!$_
item43.X-ABRELATEDNAMES:Custom Relation
item43.X-ABLabel:Customrelation
X-ACTIVITY-ALERT:type=call\,snd=system:Bulletin\,vib=Alert
X-ACTIVITY-ALERT:type=text\,snd=<none>
X-ALTBDAY;CALSCALE=chinese:007800301201
END:VCARD
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-3-28 17:20 , Processed in 0.031115 second(s), 7 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表