Thông tin thêm:
Tải phần mềm NotePad++ tại đây:
Video hướng dẫn tạo file danh bạ Vcard – VCF từ file Excel
1. Chuẩn bị sẵn 1 file Excel
2. Lưu file excel dưới dạng Unicode text.
3. Mở file TXT với NotePad++ để thay thế các khoảng cách bằng dấu “,” (dấu phẩy).
4. Convert code sang UTF-8 bằng NotePad++ và lưu file.
5. Đổi tên file thành *.csv
6. Nhập file *.csv lên danh bạ của Gmail.
7. Xuất danh bạ từ Gmail xuống thành Vcard – VCF
Bạn đăng ký kênh để cập nhập các video hướng dẫn khác nhé.
Chúc bạn thành công!
Nguồn: https://otrasnoviaxeiro.com/
Xem thêm bài viết: https://otrasnoviaxeiro.com/category/cong-nghe
Comments
admin admin December 28, 2019 at 10:13 pm
VERY USEFUL!!! Rudy from indonesia, thanx alot
Shashi Naganur December 28, 2019 at 10:13 pm
Dear Thanks for most valuable video, very helpful for needy one. God bless you .
vip vip December 28, 2019 at 10:13 pm
thank u ur information sir
مقاطع مميزة December 28, 2019 at 10:13 pm
goood
Webdrill wala December 28, 2019 at 10:13 pm
thank you so much brother
from india
Mundo do Vinicius December 28, 2019 at 10:13 pm
Thanks, guy! You helped too much! But you don't need to create a CSV file manually. You can export the file as a CSV and then import on the contacts. After it, you export from the Google Contacts. But, thank you!
OSHO ओशो December 28, 2019 at 10:13 pm
THNX SO MUCH
Mehul Chauhan December 28, 2019 at 10:13 pm
Excel to vCard Converter is designed for those users who want to export Excel database into vCard in order to manage their information in a better manner. vCard or VCF is a new way of managing data in which we can save all the information, including contact, name, address, phone number, email address and many more in a sufficient manner.
http://migrateemails.com/2015/09/10/how-to-perfrom-seamless-conversion-with-excel-to-vcard-converter/
James smith December 28, 2019 at 10:13 pm
If any naive user don' t want to use Google account to convert Excel file format ( .xls and .xlsx) format to Virtual card format (VCF) or vCard, a user can directly convert to save time and effort. Download Excel to vCard Converter: http://www.exceltovcard.com/
The tool allows the user to convert Contacts save in Excel file to the different vCar file format (2.1, 3.0, 4.0).
emonroy monroy December 28, 2019 at 10:13 pm
you can save it directly form excel as a csv you dumbass
James Britton December 28, 2019 at 10:13 pm
If you're looking for a free solution to convert Excel to vCard, you can try an easy manual trick. The manual trick doesn't require any 3rd party paid tool. You can import contacts information from the Excel files to VCF files. Refer to this article for complete information – semnaitik.com/2015/07/06/excel-to-vcard/
Eslam Naser December 28, 2019 at 10:13 pm
THANKS 🙂
Camila Oliveira December 28, 2019 at 10:13 pm
Thank you, thank you very much !!! you are the best
shalabh dwivedi December 28, 2019 at 10:13 pm
Thank you very much, it worked so well, you saved my lot of time. I don't understand Vietnamese so I used google translate. Thank you so much once again, you are a saviour.
Ariel Sarussi December 28, 2019 at 10:13 pm
songs name ????
Ariel Sarussi December 28, 2019 at 10:13 pm
song name ???
DJASARE TDOT December 28, 2019 at 10:13 pm
simple and free way to get that file into your phone contact thank you
Ram ArtCreator December 28, 2019 at 10:13 pm
Nice trick My Bro… i love ur woks thanks
Piyush Bansal December 28, 2019 at 10:13 pm
Thanks Dear
Rajesh Samprathi December 28, 2019 at 10:13 pm
Fuck this video..!! cant understand the written language ..
Pubg live December 28, 2019 at 10:13 pm
thanks boss
Vivek Aarya December 28, 2019 at 10:13 pm
thanks alot for this video…great work bro''
Ashish Chopra December 28, 2019 at 10:13 pm
Thank you!!
Ganga Sagar December 28, 2019 at 10:13 pm
good…
Animal Monkey December 28, 2019 at 10:13 pm
sao mình ko nhập vào đc mail nhỉ bảo ko đọc được file làm như bạn rồi
m.fatih Seçilmiş December 28, 2019 at 10:13 pm
Thanks so so muchhh :):)
Rupanzel Popy December 28, 2019 at 10:13 pm
Thank you sO muChhhhhh!!!!!! 😀
Dattatray Dixit December 28, 2019 at 10:13 pm
I tried but only name … contact failed….. Plz help dear….
Shiva 0479 December 28, 2019 at 10:13 pm
thank u so much
Kanwal Sumbal December 28, 2019 at 10:13 pm
Thank you, bundle of thanks, I was really in search of this since last week
Deepak Lodha Rishabh Travellers December 28, 2019 at 10:13 pm
please tell me the notepad++ code for adding second buisness address and three more mobile numbers please.
xin vui lòng cho tôi biết notepad ++ mã cho thêm địa chỉ doanh nghiệp thứ hai và ba con số di động vui lòng.
deepak k December 28, 2019 at 10:13 pm
Script :Too much complicated just open ur excel file with vb on that sheets and paste code and execute it will convert it to v-card, just import it to ur google contact, sync on phone and tadda, done, Note: keep excel column first name, last name, number with heading
'External Properties & Functions Declaration
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long,
ByVal Operation As String, ByVal Filename As String, Optional ByVal Parameters As String, Optional
ByVal Directory As String, Optional ByVal WindowStyle As Long = vbMinimizedFocus) As Long
Private Sub Create_VCF()
'Open a File in Specific Path in Output or Append mode
Dim FileNum As Integer
Dim iRow As Double
iRow = 2
FileNum = FreeFile
OutFilePath = ThisWorkbook.Path & "OutputVCF.VCF"
Open OutFilePath For Output As FileNum
'Loop through Excel Sheet each row and write it to VCF File
While VBA.Trim(Sheets("Sheet1").Cells(iRow, 1)) <> ""
FName = VBA.Trim(Sheets("Sheet1").Cells(iRow, 1))
LName = VBA.Trim(Sheets("Sheet1").Cells(iRow, 2))
PhNum = VBA.Trim(Sheets("Sheet1").Cells(iRow, 3))
Print #FileNum, "BEGIN:VCARD"
Print #FileNum, "VERSION:3.0"
Print #FileNum, "N:" & FName & ";" & LName & ";;;"
Print #FileNum, "FN:" & FName & " " & LName
Print #FileNum, "TEL;TYPE=CELL;TYPE=PREF:" & PhNum
Print #FileNum, "END:VCARD"
iRow = iRow + 1
Wend
'Close The File
Close #FileNum
MsgBox "Contacts Converted to Saved To: " & OutFilePath & " – Join Email Subscription To Get Latest
Updates"
ShellExecute 0, "Open", "http://www.teslaind.in/"
End Sub
Federico Urbinelli December 28, 2019 at 10:13 pm
Awesome trick. Good job man..
amit kotecha December 28, 2019 at 10:13 pm
thanks man..!!👍