Click TOOLS --> REFERENCES and then select Microsoft Scripting Runtime andWindows Script Host Object Model from the list and place checks in the box next to each and click OK.
Next click INSERT --> MODULE and copy and paste the code below into the blank module. Save and run the macro to automatically import and save all the individual files into Outlook.
Code:
Sub OpenSaveVCard() Dim objWSHShell As IWshRuntimeLibrary.IWshShell Dim objOL As Outlook.Application Dim colInsp As Outlook.Inspectors Dim strVCName As String Dim fso As Scripting.FileSystemObject Dim fsDir As Scripting.Folder Dim fsFile As Scripting.File Dim vCounter As Integer Set fso = New Scripting.FileSystemObject Set fsDir = fso.GetFolder("C:\VCARDS") For Each fsFile In fsDir.Files strVCName = "C:\VCARDS\" & fsFile.Name Set objOL = CreateObject("Outlook.Application") Set colInsp = objOL.Inspectors If colInsp.Count = 0 Then Set objWSHShell = CreateObject("WScript.Shell") objWSHShell.Run Chr(34) & strVCName & Chr(34) Set colInsp = objOL.Inspectors If Err = 0 Then Do Until colInsp.Count = 1 DoEvents Loop colInsp.Item(1).CurrentItem.Save colInsp.Item(1).Close olDiscard Set colInsp = Nothing Set objOL = Nothing Set objWSHShell = Nothing End If End If Next End Sub
Referance >> http://forums.techguy.org/business-applications/532618-import-multiple-vcard-files-outlook.html
http://forums.techguy.org/business-applications/532618-import-multiple-vcard-files-outlook-2.html
No comments:
Post a Comment