Macro to copy data from excel to outlook forms

[evan4ever8]

Good morning,

I need a macro that will copy the data from an excel sheet to outlook forms

I have a spreadsheet with some data in it, I also created a form in outlook that looks exactly the same as the excel one. I need a macro in excel that will copy each field in excel to the corresponding field in the outlook form.

Example:

if I have (in excel)

Name: Evan
Address: Houston

I have a form in outlook that also has

Name: ______
Adress: ______

I need a macro that will copy "Evan" and "Houston" to the outlook form.


More info:
Excel workbook is in C:\test.xlsm
Outlook form can be accessed by clicking the small arrow next to "new" then choosing "Choose form"; it will be under "Personal forms Library"