Sub ImportVCFtoOutlookContacts() Dim objOutlook As Object Dim objNamespace As Object Dim objContactsFolder As Object Dim objVCFItem As Object Dim fso As Object Dim folderPath As String Dim file As Object Dim vcfFilePath As String Dim wb As Workbook
Set wb = ThisWorkbook folderPath = wb.Path
' Outlookアプリケーションを取得 On Error Resume Next
If objOutlook Is Nothing Then Set objOutlook = CreateObject("Outlook.Application") End If On Error GoTo 0
' Namespaceと連絡先フォルダを取得 Set objNamespace = objOutlook.GetNamespace("MAPI") Set objContactsFolder = objNamespace.GetDefaultFolder(10) ' 10 = olFolderContacts
' FileSystemObjectを使用してフォルダ内のファイルを操作 Set fso = CreateObject("Scripting.FileSystemObject")
' フォルダ内のすべての.vcfファイルを処理 For Each file In fso.GetFolder(folderPath).Files If LCase(fso.GetExtensionName(file.Name)) = "vcf" Then vcfFilePath = file.Path Set objVCFItem = objOutlook.CreateItemFromTemplate(vcfFilePath) objVCFItem.Move objContactsFolder End If Next
MsgBox "すべてのvCardファイルがOutlookの連絡先にインポートされました。" End Sub ```