Good morning all,

I am trying to create a macro in Excel that will create a subfolder in Outlook and a directory folder using the data in cells to name it.

I use the workbook to record loans I am processing and along the way, my customers send me emails. Row 1 is used for headers, so I dont need the macro to look at row 1 at any time for data.

After entering the data in the row for my customer, I would like 2 things to happen with this macro.

1. Create a subfolder in Outlook under the folder 'Members' using their Surname in Column H and their Customer Number in Column D. eg. 'Smith 123456'.
2. Create a directory folder under H:\applications\ using the same format as the Outlook Folder naming.

Of course, as it runs down the column, if the folder already exists, try not to add a copy, merely just add the ones that are no currently created. or Possibly, add the folder of the row the cursor is curently in.

Happy to provide a dummy sample of my workbook if needed.

Look forward to hearing from anyone who can help out

Tayler