Looking up and Converting a List of Notes Names into their Email Address
||January 17, 2021 at 7:57 AM
||When asked to pull the email names for a list of Notes names so marketing could export them to an outside mailing list, I figured there had to be a better way than looking them up individually. Luckily, there is.
This version owes a hat tip and thanks to the inspiration code from the amazing Stephan Wissel and this post of his: https://www.wissel.net/blog/2011/10/converting-notes-names-into-internet-addresses.html
I had to adjust the code over time a little bit but I also want to give credit where it is deserved.
HOW TO USE THIS CODE:
This will create a button in your Toolbar.
1. Go to File->Preferences->Toolbar->Customize from your Notes client.
2. From the top box, I Customize the Universal toolbar so select it from the dropdown.
3. Below the window box of icons, Click on New->Button.
4. Give it a Caption text, I used: Get Email Addresses.
5. Popup Help text really is the name that shows when you hover over the icon, I would just repeat the name used in Step 4.
6. Change the icon to something either meaningful (toolbar_ccmail.gif icon perhaps?) or whatever will be unique for you to notice it.
7. Paste the code from the code box on this page into the Formula box of your Toolbar Icon window.
8. Click Ok.
9. Click Save Toolbar.
10. Click Ok.
That concludes the code part of this snippet.
HOW TO USE THE CODE:
1. If you don't have the Universal Toolbar showing by default, turn it on by going to View->Toolbar and clicking on Universal
2. Open your PNAB (Personal Address Book), also called Contacts of your Notes client, it is usually the names.nsf file.
3. Click on Groups from the list of options in your Contacts.
4. Click on New to create a new Group.
5. You can name it anything, I keep a generic empty group for this purpose and call it Converts.
6. In the main field, copy and paste the names to get emails from your company NAB/Directory.
7. Click Save and Close.
8. Now with the group you created highlighted/selected, click on the Icon created in the toolbar we created earlier.
9. You will receive a pop-up window one completed stating Found XX emails for XX Notes Names. This is important so you know if you got everyone or if you had any typing mistakes or people who may have left the company.
10. Now if you open the group you will see the emails for everyone in the Comments & Attachments section.
Cool, right? I taught AA's how to use this and they love it and never bother me anymore.
If you used this and it helped you great! Please rate it and let me and Stephen know you used the code.
I am @Lotusevangelist and Stephan is @notessensei on Twitter
result := "";
realresult := "";
@For (n := 1;n <= @Elements (Members );n := n + 1;
look := @Trim ( @NameLookup ( [Exhaustive];Members [n ]; "InternetAddress" ) );
realresult := @Trim ( @Unique (realresult:look ) );
result := @Trim ( @Unique (result : @If (look= "";@Name ( [Abbreviate];Members [n ] );look ) ) ) );
FIELD comment := @Implode (result;@NewLine );
@Prompt ( [Ok]; "Members " + @Text ( @Elements (Members ) ); "Found " + @Text ( @Elements (realresult ) )+ " emails for "+ @Text ( @Elements (Members ) )+ " Notes Names" )