Can I import data to Outlook (2000) using VBA?

[rickmasters]

Hello,

I am trying to import data to Outlook from Access (2000). The import function in Outlook works fine, but I need to automate the whole process from a single button, so what code do I need to put behind that button?

I would really appreciate some help with this, many thanks.

 

[superspeed]

You can import a file in a routine. This is a routine that I used. FolderName is a global variable with the path to the file.

Sub ImportData(CSV_file As String, Access_Table As String)

Dim DataFile As String
DataFile = FolderName + CSV_file

' Call MsgBox(DataFile, vbInformation, "Importing&quot
Call ClearImportFile(Access_Table)
DoCmd.TransferText , , Access_Table, DataFile, True

End Sub