Consulting

Page 1 of 3 1 2 3 LastLast
Results 1 to 20 of 53

Thread: Solved: Excel info to Outlook Form

  1. #1
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,938
    Location

    Solved: Excel info to Outlook Form

    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.

  2. #2
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    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)
    ~Anne Troy

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,938
    Location
    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.

  4. #4
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    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...

    ~Anne Troy

  5. #5
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    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

  6. #6
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,938
    Location
    Suat,

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

  7. #7
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    Strange, I just downloaded it and it seems fine.

    ??

  8. #8
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,938
    Location
    Just noticed I can't unzip ANY file from the board. This is frustrating..

  9. #9
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    Shall I send via email ??

  10. #10
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,938
    Location
    sure, thanks.

    firefytr@ here .com

  11. #11
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Yep. It worked for me, dude.
    Might check your Winzip.

    Suat!! How was your vacation??
    ~Anne Troy

  12. #12
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    sent

  13. #13
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,938
    Location
    Got it. Same message, 'No files to extract'. Grrrr. Any ideas? I've not seen/delt with this one before.

  14. #14
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    Quote Originally Posted by Dreamboat
    Suat!! How was your vacation??
    I got back on Wednesday unexpectedly and terrible just after vacation, Anne. Terrible... Recently too bad mood.

  15. #15
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    Sending xls, Zack.

  16. #16
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    sent

  17. #17
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    I sent without the Zip, Zack.

    I'll talk to you on YIM, Suat.
    ~Anne Troy

  18. #18
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,938
    Location
    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?

  19. #19
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    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

  20. #20
    BoardCoder VBAX Regular
    Joined
    May 2004
    Location
    Istanbul, Turkiye
    Posts
    73
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •