Question: I would like to create a mail merge to Outlook email so that I can customize the content based on various fields of information. I appeared to follow the steps correctly but no messages were sent? Is this feature disabled at UNMC?
Answer: I had the same problem when I tried merging to Outlook. After much searching on the web, I discovered the problem seems to stem from your computer workstation not understanding that Outlook is your default mail program. Even if you have set your default programs in the Computer Control Panel, it may not be correct in your regedit.exe file. You can change this file (follow steps carefully or have a workstation or Helpdesk staff assist):
- Click on Start (or Windows button) in lower left of workstation desktop and in the search area type “regedit.exe”
- Browse to HKEY-LOCAL_MACHINE > Software > Clients and click on Mail
- Check what appears in the right pane. It should read: (Default) REG_SZ Microsoft Outlook
- If Microsoft Outlook does not appear, right click on (Default) and click on Modify and in the value data box, type Microsoft Outlook
- Restart Word and you should now be able to use the Mail Merge to Email feature successfully.
If you have questions, please contact firstname.lastname@example.org or email@example.com.
Question: In order to analyze my worksheet and compare it with another, I need to split cells apart into separate columns. I have been trying to use if formulas, but can’t seem to get it to work.
Answer: I try to avoid complex formulas whenever possible, so the easiest way to do this, as long as there are consistent characters or spaces, is to use Excel’s text to columns feature.
- Determine how many columns you will need (including the current cell) and insert them to the right of your cell that needs to split. If you need 3 columns for your data, you will need to add 2 columns.
- Select the cells you want to split
- Click the Data tab and select the Text to Columns button in the data tools group. The text to columns wizard appears.
- Select delimited if you have consistent text. If you have a certain number of characters, you can select fixed width. Click Next.
- If you selected delimited, choose the character to use to separate your text. (such as comma) If you don’t see the character, select Other and type in the character). If you selected Fixed Width, click the ruler where you want to separate text.
- Assign data type to the new columns (if necessary)
- Click finish.
In this example, they needed two digits, so to add zeros before single digits in the new columns. We used the Replace All (found under the Home Tab – Find/Select) to each single digit 1, 2, 3, etc. and replaced all with ’01 or ’02 or ’03, etc. That allowed the zero to display in a text field.
Question: Is there a way to generate a report of time from your outlook calendar if you’ve used the “categorize” function? Or generate any type of reports from your Outlook calendar?
Answer: Yes, you certainly can create reports. From your calendar view, select View > Change View and select the List view. You’ll see your entries listed in column/row format. You can sort on headings, including a category. You can then select the entire list or a partial list and copy and paste into an email message, Word, or better yet, into Excel so that if you wanted to use filters or pivot tables, you can do that, and modify any way you want without affecting your calendar entries.
Question: When I start typing a name I like the auto complete finds a name I’ve recently corresponded with. However, I have an incorrect address and would like to delete it? In Lotus Notes I could just go in and delete them from the Recent Contacts in the Contact view. But I don’t even know where to find them in Outlook
Answer: In Outlook you should see “Suggested Contacts” (which would be the same as recent contacts) in your Contact view, but in some cases I have heard that people don’t have that option. Even if you do, I have found that the “incorrect” name may not be listed to delete.
So, the better option is actually very easy. When you start typing the name and the “suggested” name automatically pops up, press the x to delete the name if you’re in Outlook 2010. Or just press the delete key on the keyboard. On the Mac, you may need to hold the function key with Delete. Thereafter name should no longer pop up.
I know basic features of Word but would like learn more advanced features without having to sit through a lot of training. What do you recommend?
UNMC ITS recommends their short mini-sessions which are often available, as well as videos, demos and tutorials that Microsoft offers free of charge. Click here to see a variety of excellent short videos on: opening Word really fast, using office.com templates, convert a list into a table, make bulleted list more interesting, cropping pictures to shapes, zooming with your mouse, and more! All videos are three minutes or less.
The next ITS Word mini-session is Tuesday 11/13 from 10-11:30 and will feature Word Graphics features, including working with photos, text boxes, diagrams and more. Feel free to bring your own documents to “dress up.” Learn about Mail Merge on December 5 from 10-11:30 a.m. to create letters, labels or envelopes from your mailing lists in Excel or Access. We will also have “drop in help” sessions following those sessions from 11:30-12:30 to for individual help with projects (Word or other applications). These sessions will be held in 8011 Wittson and require registration at http://www.unmc.edu/its/training.htm (you don’t need to register for drop in sessions). If you have requests for additional Word training, contact firstname.lastname@example.org