?
Solved

How do I create a new Outlook folder from Excel ?

Posted on 2013-11-09
11
Medium Priority
?
293 Views
Last Modified: 2013-11-10
Hi,

I would like to create a new named Outlook folder from within my Excel 2010 application.

The folder name will be input by the user and appended to the following Outlook folder structure :

Personal Folders/Orders/

I'm not sure where to begin with this.

Thanks
Toco
0
Comment
Question by:Tocogroup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
11 Comments
 
LVL 23

Expert Comment

by:Michael Fowler
ID: 39636637
Try this, it is based on an example here
http://social.msdn.microsoft.com/Forums/en-US/768649d6-be9a-4543-ba0a-9c0a31f1aa7b/working-with-outlook-public-folders-from-excel

Dim OL As Outlook.Application
Dim NS As NameSpace
Dim APFs As MAPIFolder      'All Public Folders
Dim MYPF1 As MAPIFolder  'My Pub Folder 1
Dim NewItem As PostItem
  
Set OL = CreateObject("Outlook.Application")
Set NS = OL.GetNamespace("MAPI")
Set APFs = NS.Folders("Public Folders").Folders("All Public Folders")

  ' Enter a valid Public Folder Name below
Set MYPF1 = APFs.Folders("Orders")

MYPF1.folders.Add("Test")

Open in new window

0
 

Author Comment

by:Tocogroup
ID: 39636660
I'm getting a 'User-defined type' error at run-time. Please see attached screenshot.
0
 

Author Comment

by:Tocogroup
ID: 39636661
Let's try uploading the file this time
Create-OL-folder-screenshot.jpg
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 40

Expert Comment

by:als315
ID: 39636678
Look at sample
You will need some libraries in your project (Tools-References in VBA Editor):
referencesAddFolder.xlsm
0
 

Author Comment

by:Tocogroup
ID: 39636746
Ok. I got a little further down the line with a different runtime error (see attached screenshot) on the Set APFs line.
Create-OL-folder-screenshot-erro.jpg
0
 
LVL 40

Expert Comment

by:als315
ID: 39636890
Tocogroup: have you tested my sample?
0
 

Author Comment

by:Tocogroup
ID: 39636906
Hi als315.

Yes I have tested your sample. Hence the screenshot and post above of the second runtime error.
Just to confirm, I checked the libraries as per your screenshot.
0
 
LVL 40

Expert Comment

by:als315
ID: 39636972
Screenshot above is with code from Michael74.
Do you like to add folder to public folders or to personal folders?
0
 

Author Comment

by:Tocogroup
ID: 39637159
Personal folders.
I tried replacing 'Public folders' with 'Personal folders' but had the same runtime error.
0
 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 39637169
I should ask again: have you tested my sample? If there are any errors, can you show them?
0
 

Author Closing Comment

by:Tocogroup
ID: 39637327
Apologies als315. My error !

I've copied your sample into my application and it works absolutely fine.

Many thanks for your patience
Toco
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question