jordanf563
New Member
- Joined
- Apr 16, 2013
- Messages
- 1
Hi All,
I am very much still a rookie here and in developing in general. I am running into a bit of an issue with a Add-in I am designing.
Basically, I am trying to write an add-in that does 2 things,
1. Allows a user to create a certain report based on a choice of possible reports via a drop down - DONE
2. Allows a user to automatically generate an email based on a selection of possible emails via another drop down. - ISSUE
I am designing the second part of the Add-in to open Outlook, and generate an email based on certain templates I have saved. Well the problem is that I will installing this add-in serveral users computers and the location for the templates will obviously be different on everyones computers, (e.g. C:\Users\*USERNAME*\AppData\...etc).
When I made this as a macro I was able to just set a myPath variable to save the macros location and was able to get the users name from that path. But I have no idea if that is even possible to do with a Add-in seeing as it isnt running in a workbook.
Any ideas on how to figure out where the templates are being stored? I cannot use the get username because my company's requires everyone to save to a network drive that is different than the username.
I am very much still a rookie here and in developing in general. I am running into a bit of an issue with a Add-in I am designing.
Basically, I am trying to write an add-in that does 2 things,
1. Allows a user to create a certain report based on a choice of possible reports via a drop down - DONE
2. Allows a user to automatically generate an email based on a selection of possible emails via another drop down. - ISSUE
I am designing the second part of the Add-in to open Outlook, and generate an email based on certain templates I have saved. Well the problem is that I will installing this add-in serveral users computers and the location for the templates will obviously be different on everyones computers, (e.g. C:\Users\*USERNAME*\AppData\...etc).
When I made this as a macro I was able to just set a myPath variable to save the macros location and was able to get the users name from that path. But I have no idea if that is even possible to do with a Add-in seeing as it isnt running in a workbook.
Any ideas on how to figure out where the templates are being stored? I cannot use the get username because my company's requires everyone to save to a network drive that is different than the username.
