This forum is for the discussion of Microsoft Outlook. You may also discuss Email in general, or if you are using Outlook Express or Windows Mail, that's fine too.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

New Outlook Classes Link  Richard Rost      5/23/2020 Show of hands... who here is still interested in learning Outlook? Post a comment here. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Form letters in Outlook 2013 Link  ColinM     3/23/2015 Alex.  I appreciate your reply, however, I really don't understand how I would revise the VBA code.  Please explain. Thanks. Reply from Alex Hedley: I'm away from a computer for a few days so would have to look at it when I'm back but it's an argument you can pass to explorer and the shell command. Read More... Doesn't look as easy as I thought it would be. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Form letters in Outlook 2013 Link  ColinM     3/22/2015 Alex.  Got this to work! Yeh!  One issue with it.  The button opens a folder that has a number of Microsoft templates in it that open Word, etc, as well as the Outlook Templates I created. Is there a way to modify the VBA code so that it ONLY shows my Outlook Templates? Read More... Reply from Alex Hedley: I've not tested but you could do something: Searching Call Shell("explorer.exe ""search-ms://query=filename:t*.doc foldername:Workshop size:small""") (file:*.doc folder:C:\Workshop) The other option is the FileDialog which does allow a Filter to be added. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Form letters in Outlook 2013 Link  ColinM     3/21/2015 Hi Alex.  Thank you!  I followed you right up to the following: "Click the Visual Basic Button Add the following code:" When I click the Visual Basic Button, I get a gray screen.  Where do I go from there? Read More... Also, one other question:  what do you mean by " Swap USER to your Username"? I didn't get to this step, because of the problem opening the Visual Basic button. What "your Username" are you referring to? Reply from Alex Hedley: On the left hand side there is Project Window If not 'View | Project Explorer (Ctrl+R)' Expand Project1   Microsoft Outlook Objects    ThisOutlookSession Double Click this to open a VBA code window on the right. Paste the code there. Save. Your Username, the name you type in before your password to get into your user account on the computer. aka Login name. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Form letters in Outlook 2013 Link  Alex Hedley     3/20/2015 *Note I did this in 2010 but should work the same in 2013 File | Options Customise Ribbon Tick Developer, OK Select the Developer Ribbon Custom Forms section Choose Form Look in: User Templates in File System Read More... This shows the folder of C:\Users\USER\AppData\Roaming\Microsoft\Templates\*.oft Is this the Folder you wish to open? Click the Visual Basic Button Add the following code: Sub OpenFolder()     Dim Foldername As String     Foldername = "C:\Users\USER\AppData\Roaming\Microsoft\Templates"     'Foldername = "%UserProfile%\AppData\Roaming\Microsoft\Templates\"          Shell "C:\WINDOWS\explorer.exe """ & Foldername & "", vbNormalFocus End Sub Swap USER to your Username Now in the Quick Access Toolbar More Commands... Macros Choose the Macro Add >> Change the Name and Icon. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Show Older Posts