Create Outlook contact from Qlikview

[#1]

Hi all,

I'm attempting to generate a new Outlook contact from Qlikview with a macro. I have the following code;

Set spObj = CreateObject("Outlook.Application")

Set MyItem = spObj.CreateItem(olContactItem)

MyItem.Display

Even though I have oIContactItem, Qlikview opens a new message instead of a new contact...Does anyone know how to get a new contact and not a message? thanks in advance!

[#2 · Accepted solution]

figured it out! here is the code:

Set spObj = CreateObject("Outlook.Application")

Set MyItem = spObj.CreateItem(2)

MyItem.Display