How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Jason Fenoglio Your Own Question
Jason Fenoglio
Jason Fenoglio, Sr. Systems Engineer
Category: Email
Satisfied Customers: 266
Experience:  Sr. Systems Engineer
Type Your Email Question Here...
Jason Fenoglio is online now
A new question is answered every 9 seconds

Outlook 2010 - Macro that references my .oft Templates. In

Customer Question

Outlook 2010 - Macro that references my .oft Templates.
In order to "share" my templates, I have put them into a folder in Dropbox - how do I edit the Set newItem line so it will open the template in Dropbox? The bigger part of this question is I want to be able to export / import this macro with other users in my office, and I don't want to edit the macro everytime I import it on their computer.
Sub Email()
Set newItem = Application.CreateItemFromTemplate("c:\Users\Mark's Office\AppData\Roaming\Microsoft\Templates\Email.oft")
Set newItem = Nothing
End Sub
Submitted: 1 year ago.
Category: Email
Expert:  Jason Fenoglio replied 1 year ago.

Hi my name is ***** ***** I can assist. I don't believe that you can pull it from Dropbox since it is a application the attaches a cloud connection to your file system. You might try using a environment variable instead of a direct path. You could use %USERPROFILE%\AppData\Roaming\Microsoft\Templates\Email.oft and save the .oft file in the same spot. Every user that logs on, %USERPROFILE$ will be relative to them.

Expert:  Jason Fenoglio replied 1 year ago.

If you are on a domain, you could also use Group Policy to place the template in the user profile for everyone just using the same path with the environment variable.

Expert:  Jason Fenoglio replied 1 year ago.

Just checking in with you. Did the answer above help at all?