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

Leave a Reply

Your email address will not be published. Required fields are marked *

Comments

admin admin December 28, 2019 at 10:13 pm

VERY USEFUL!!! Rudy from indonesia, thanx alot

Reply

Shashi Naganur December 28, 2019 at 10:13 pm

Dear Thanks for most valuable video, very helpful for needy one. God bless you .

Reply

vip vip December 28, 2019 at 10:13 pm

thank u ur information sir

Reply

مقاطع مميزة December 28, 2019 at 10:13 pm

goood

Reply

Webdrill wala December 28, 2019 at 10:13 pm

thank you so much brother
from india

Reply

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!

Reply

OSHO ओशो December 28, 2019 at 10:13 pm

THNX SO MUCH

Reply

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/

Reply

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).

Reply

emonroy monroy December 28, 2019 at 10:13 pm

you can save it directly form excel as a csv you dumbass

Reply

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/

Reply

Eslam Naser December 28, 2019 at 10:13 pm

THANKS 🙂

Reply

Camila Oliveira December 28, 2019 at 10:13 pm

Thank you, thank you very much !!! you are the best

Reply

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.

Reply

Ariel Sarussi December 28, 2019 at 10:13 pm

songs name ????

Reply

Ariel Sarussi December 28, 2019 at 10:13 pm

song name ???

Reply

DJASARE TDOT December 28, 2019 at 10:13 pm

simple and free way to get that file into your phone contact thank you

Reply

Ram ArtCreator December 28, 2019 at 10:13 pm

Nice trick My Bro… i love ur woks thanks

Reply

Piyush Bansal December 28, 2019 at 10:13 pm

Thanks Dear

Reply

Rajesh Samprathi December 28, 2019 at 10:13 pm

Fuck this video..!! cant understand the written language ..

Reply

Pubg live December 28, 2019 at 10:13 pm

thanks boss

Reply

Vivek Aarya December 28, 2019 at 10:13 pm

thanks alot for this video…great work bro''

Reply

Ashish Chopra December 28, 2019 at 10:13 pm

Thank you!!

Reply

Ganga Sagar December 28, 2019 at 10:13 pm

good…

Reply

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

Reply

m.fatih Seçilmiş December 28, 2019 at 10:13 pm

Thanks so so muchhh :):)

Reply

Rupanzel Popy December 28, 2019 at 10:13 pm

Thank you sO muChhhhhh!!!!!! 😀

Reply

Dattatray Dixit December 28, 2019 at 10:13 pm

I tried but only name … contact failed….. Plz help dear….

Reply

Shiva 0479 December 28, 2019 at 10:13 pm

thank u so much

Reply

Kanwal Sumbal December 28, 2019 at 10:13 pm

Thank you, bundle of thanks, I was really in search of this since last week

Reply

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.

Reply

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

Reply

Federico Urbinelli December 28, 2019 at 10:13 pm

Awesome trick. Good job man..

Reply

amit kotecha December 28, 2019 at 10:13 pm

thanks man..!!👍

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *