Solved: Excel info to Outlook Form

[Zack Barresse]

Hi,

I've got an Excel UserForm. What I'm looking to do, is take the data from a Combo Box (ComboBox1) in this UserFrom from Excel, and place it in a Custom Form in Outlook. This would be going to ComboBox1 in the Outlook form. I'm attempting to call this Form from Excel.

Let me know any additional information that should be posted, I'm an Outlook doof and know next to nothing.

[Anne Troy]

Question: Why use Excel at all?
IOW, wouldn't it be easier to store the data from the userform to a cell, and then use the cell to dump to Outlook form?

You *do* know you can't just go sending Outlook forms *out there*, right? They're really best with internal tasks. Unless you're talking about an Outlook TEMPLATE (oft)

[Zack Barresse]

Oh, yeah, that's what I'm talking about. It is an OFT file. And I can always add a temp sheet to write the data to or something, that wouldn't be a problem. It's just getting the info TO the template, is where I'm lost.

[Anne Troy]

And the OFT has something that a regular message doesn't?
I'm trying to figure out what the message has that can't be done with a straight email...

[smozgur]

Hi Zack, Anne

Zack, I assumed that you have a custom message form in OL named as NewForm. And this form has a combobox control on it named as ComboBox1.

Please look at the attachment to see if it might help.

It basically loads that custom form in OL and fills in the combobox1 on OL form with data currently in Excel userform's combobox1 and selects the selected item in Excel userform then display the form.

I hope I understood it correctly.

Suat

[Zack Barresse]

Suat,

That sounds EXACTLY like what I have. But I couldn't extract your zip, it says there were no files to extract. ??

[smozgur]

Strange, I just downloaded it and it seems fine.

??

[Zack Barresse]

Just noticed I can't unzip ANY file from the board. This is frustrating..

[smozgur]

Shall I send via email ??

[Zack Barresse]

sure, thanks.

firefytr@ here .com

[Anne Troy]

Yep. It worked for me, dude.
Might check your Winzip.

Suat!! How was your vacation??

[smozgur]

sent

[Zack Barresse]

Got it. Same message, 'No files to extract'. Grrrr. Any ideas? I've not seen/delt with this one before.

[smozgur]

Suat!! How was your vacation??

I got back on Wednesday unexpectedly and terrible just after vacation, Anne. Terrible... Recently too bad mood.

[smozgur]

Sending xls, Zack.

[smozgur]

sent

[Anne Troy]

I sent without the Zip, Zack.

I'll talk to you on YIM, Suat.

[Zack Barresse]

Got it, from both. Thanks! Not sure what that was all about.

So Suat, in your code the line ...

[vba] Set objItem = objFolder.Items.Add("IPM.Note.NewForm")[/vba]

Would I have to specify a path (could I) to the location of this Form? Currently it's in a seperate folder along with an Excel add-in from which it will be called. I can get the path no problem, but how would I go about telling where to find this specific form?

[smozgur]

Hmm.. Zack, I assumed that form is saved in OL Personal Forms Library.

I missed that it is a standalone file in a real folder. I'll see what I can do about it.

Suat

[smozgur]

Zack, did you try the code in a form that is saved in OL instead as an OFT file ?

Just curious. I will be able to modify it for the OFT file tomorrow.