Outlook 2010 - outlook userform and combo boxes

Status
Not open for further replies.

Falina

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
To Whom It May Concern,

Hello, I am a new student here. I have been following your YouTube on the subject "Outlook Userform and Combo boxes". I have created the user form, follow your codes, it run the User Interface but it doesn't run on the modules. Here are the images, that I have unknown what to do next:-

upload_2014-6-2_10-1-48.png



So, could you help me?

Thanks.
 

Falina

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Hi,

Here are the codes from the module that the system found as a debug.

upload_2014-6-2_10-8-1.png


We hope to hear from you soon.

Thanks.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The yellow indicates that line is the problem - the dialog in the first screen shot says the template can't be opened. Did you save an Outlook template with that name in that location?

You can add debug.print strTemplate right before the set oMail = line - it will write the path to the Immediate window (Ctrl+G to open it) and you can verify it exists - then double click on the file and see if it opens for you.
 

Falina

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Hi Diane,

Here is the template that I have created in this folder - named " template-1".

upload_2014-6-2_11-0-15.png


About the debug.print, do you want me to add on like this as below:-

strTemplate = "C:\Users\Falina\Email\" & debug.print strTemplate & ".oft"
Set oMail = Application.CreateItemFromTemplate(strTemplate)

We hope to hear from you soon. Thanks.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If you double click on the template, does it open ok?

The debug code is added like this:

strTemplate = "C:\Users\Falina\Email\" & strTemplate & ".oft"
debug.print strTemplate
Set oMail = Application.CreateItemFromTemplate(strTemplate)


copy the path from the Immediate window and paste it in the address bar of windows explorer - does it open?

File permissions should be ok since its under your user account, but you can verify that as well.
 

Falina

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Hi,

The template can display when I double click on it.

I have copy your codes as the above, but unfortunately it shows the same error debug as the above.

upload_2014-6-2_14-5-57.png


Codes:-

upload_2014-6-2_14-6-50.png


Could you show me in a print screen way?

Hope to hear from you soon.

Thanks.
 

Falina

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Hi,

By the way, I am using outlook 2010. Does it help to create it? As I saw your video, you are using the Outlook 2013.

Thanks.
 

Falina

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Hi

Could you do it the step by step on the "Outlook Userform and Combo boxes" using Outlook 2010 and creating templates that link to the path.

I would be very appreciated it can also help other user as well.

Thanks.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
the version won't matter, 2010 and 2013 are essentially the same for VBA. In fact, this macro should work in 2003 and up, and will probably work in 2000 and up. But I will test it to double check.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I tested it -- it worked when the path was correct.
Are you using the same case for the template names? It usually doesn't matter with filenames and didn't here.

I was able to trigger the same when i forgot to change the username in the path - there is no "C:\Users\me\Template\" - and for whatever reason, windows told me i had a Templates folder in that path already so i used Template. (I'm showing hidden files and folders and don't see the Templates folder.)

I added the template path string to the subject so i could see which template it was loading - I triggered the same erro you got only when the path circled in red was incorrect.
template-test.png
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
e_a_g_l_e_p_i Can emails from Gmail be deleted when they are downloaded to Outlook 2010 Using Outlook 1
L Outlook 2010 Outlook 2010 Outlook VBA and Custom Forms 2
C What folders are needed when reinstalling Outlook 2010 Using Outlook 0
e_a_g_l_e_p_i Gmail in Outlook 2010 preview issue Using Outlook 4
e_a_g_l_e_p_i Outlook 2010 Help setting up Gmail account in Outlook 2010 Using Outlook 3
B Outlook 2016 Unable to view images or logos on the outlook 2016 emails the same html code works well when i use outlook 2010 Using Outlook 0
M Outlook 2010 Outlook 2010 with O365 / Exchange Online Using Outlook 0
F Outlook 2010 Outlook 2010 and GMail Using Outlook 0
D Outlook 2007 vs. Outlook 2010 -- ToDo Bar Using Outlook 0
e_a_g_l_e_p_i I think it may be time to upgrade from Outlook 2010 Using Outlook 3
T Why does outlook 2010 convert only some forum notifications to plain text? Using Outlook 0
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
D Outlook 2010 account setup fails in particular domain Using Outlook 3
B Outlook 2010 is Auto Purging when not configured for that Using Outlook 1
W Outlook 2010 Reading Pane Slows Startup Using Outlook 3
S Outlook 2010 unable to change default font Using Outlook 7
B Outlook 2010 Can not find a certain file in M/S Outlook 2010. Using Outlook 1
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
W Outlook 2010 some sent items marked unread now (was Ok before) Using Outlook 0
RBLampert Updating from Outlook 2010 to Outlook 365 Using Outlook 0
L What are the risks of opening an Outlook 2016 .pst file in Outlook 2010? Using Outlook 4
S Unable to remove rule outlook 2010 Using Outlook 0
N Outlook 2010 Flag blocked for Safe Senders List???? Using Outlook 7
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
Mark Foley Unable to subscribe to published calendar in Outlook 2010 Using Outlook 4
K Maximum Categorize Shortcuts In Outlook 2010? Using Outlook 1
E Unable to open Outlook 2010 after adding new email account Using Outlook 4
RBLampert Outlook 2010 no longer (?) shrinks large images Using Outlook 4
N Outlook 2010 will not send nor receive Using Outlook 4
U Outlook 2010 'freezes' before moving emails Using Outlook 2
P Outlook 2010 trusted emails going to spam folder Using Outlook 18
E Outlook 2010 Subject sort uses Thread-Topic for grouping Using Outlook 2
King Mustard Maximum Categorize shortcuts in Outlook 2010? Using Outlook 1
C Outlook 2010 keeps asking for username and password Using Outlook 1
M Duplicate Primary Mail Accounts outlook 2010 Using Outlook 0
T Compacting Outlook 2010 OST results in old emails being re-sent Using Outlook 6
K Outlook 2010 duplicate download emails 1 inbox 1 PST no updates Using Outlook 3
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
RBLampert Outlook 2010 sends to/receives from some Gmail addresses but not others Using Outlook 3
e_a_g_l_e_p_i Question about address book in Outlook 2010 Using Outlook 9
e_a_g_l_e_p_i Is there a good third party SPAM filter that intergrates with Outlook 2010 Using Outlook 7
e_a_g_l_e_p_i Another reinstall of Outlook 2010 issue Using Outlook 10
S Outlook 2010 Cannot Open Attachments Using Outlook 14
Justo Horrillo Issue with rules in Outlook 2010 Using Outlook 4
L Upgrade from Outlook 2010-any reason to? Using Outlook 1
C Attached Files outlook 2010 Using Outlook 1
C Attached files on Outlook 2010 Sp1 & Exc 2013 are missing Exchange Server Administration 1

Similar threads

Top