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

Word Mail Merge to Email – Microsoft Office Repair

Question: I am having a problem with my mail merge from Word to Outlook not processing. I keep getting a pop-up screen asking me to accept but if I do, it looks like emails are working but nothing appears in my Outlook sent folder. Answer: After identifying that she had Outlook set as her default mail system (See previous post), I discovered that one suggestion in an online forum was to run a Microsoft repair, by Click Start > Control Panel > Programs > Programs and Features. 2.   Click… Continue Reading

Margin release in Word

Question: Do you know how to margin release in Word? Answer: I’m not sure exactly what your goal is, but if you want to extend your text appear to the left of your margin, you can select the text and go into the paragraph dialog box (slanted arrow in the paragraph category on the Home tab or Page Layout tab and click the down arrow on the Left Indent, making it a negative –  indent (such as -.5 which would mean outdented 1/2 inch) If… Continue Reading

Word Tables

Question: I received a Word document with a table consisting of many small columns. The text in the columns does not seem to wrap correctly. Is there anything I can do? Answer: In this example, we used the Autofit Window option rather than Autofit Contents to which seemed to correct the issue. This is found on the Layout tab under Table Tools.

Customizing an MS Office Organizational Chart

Question: I am working on an organizational (hierarchy) chart from SmartArt in Word. I would like to merge two of the boxes into one but keep the two lines above it. However, I am not able to do that in the SmartArt features. Any ideas? Answer: If you copy and paste the org chart into PowerPoint, you’ll have a few more features in SmartArt. One of those is the ability to convert the SmartArt into shapes. Once you do that, however, you will not be able to… Continue Reading