Learn IT

Mail Merge to Outlook with filters, attachments and more!

Question: I have an Excel spreadsheet with data I would like to merge to Outlook. I need to include a survey as an attachment with their specified information and have them return it to me. I only want it to go to names that are highlighted in my spreadsheet. There will be over 300 names. Answer: Oh, I love these challenges. First, in order to be able to identify the names to select from Excel, there has to be something consistent about how they are… Continue Reading

Updating Outlook Groups from Excel Lists

Question: I created contact groups some time ago with around 100 names each, since Outlook won’t allow personal group with 300 names (1A, 1B, 1C) I keep the master list in Excel but it has been quite a long time since I updated the groups, and I can’t remember how I can get them updated. Answer: The easiest way to do this is to have your Excel list open, along with your Outlook contacts. Open the first group 1A, and remove the names (use Ctrl… Continue Reading

Auto reply from shared Outlook Email account

Question: I need to send an auto-reply for our generic (shared) email account. It appears I can only use auto-replies for my personal account. I also tried creating a rule but didn’t have any luck with it working. Answer: The easiest solution is for the owner of that shared account to use Outlook web access (http://owa.unmc.edu) to set up an autoreply. Log into the unmc_domain with your personal username and password. Then click in the upper right corner dropdown next to your name and change… Continue Reading

Shared calendar permissions

Question: Our department master calendar is kept in Outlook.  All the faculty have access to look at it.  They would like for the students to have access to look at it too (but NOT edit) but the system will not let me give them access.  The message says that the students are outside of our system.  Is there any way to let them look at the actual calendar rather than having to make a .pdf of it and post it to blackboard?  The schedule changes… Continue Reading

Shared calendar on an iPhone

Question: We would like our staff to be able to see the conference room calendar from their iPhone, but see that we can only see our personal calendar and not shared calendars. Is there another option? Answer: Unfortunately, there doesn’t appear to be a way to do that, other than using the browser and logging into your account and selecting the shared calendar. However, if the calendar doesn’t change more than weekly or monthly, some departments take a screen print of that calendar in weekly or monthly… Continue Reading