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 the Office program you want to repair (Word and Outlook), and then click Change.
3. Click Repair > Continue.
Since we were not able to determine any other problem with her mail merge, she tried this and indeed, it corrected her problem!
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 you want to place text to the left of the margin, like a script, you may want to use a table format.
You can also create a text box and place the text box to the left of the margin. Here are a few other suggestions for placing text outside the margin – http://wordfaqs.mvps.org/MarginalText.htm
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.
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 add more levels to your org chart through the SmartArt features. So before doing this, I would make a duplicate of that slide in case you need to refer back to the SmartArt and add more levels (or at least finalize the remainder of the org chart first).
On the duplicated slide click on the SmartArt and from the Design tab on the ribbon click to the far right Convert > Convert to Shapes. After converting to shapes you can delete one of the shapes that you wanted to merge and just stretch out the other one and add any additional text you need. Converting to shapes will allow you a little more flexibility in dealing with the individual elements of the chart.
Question: How can one merge excel currency cell into Word letter mailing to print correctly? All things that I have tried prints the amount as15897 instead of $15,897. I just wondered if you have a quick fix so I don’t have to go in manually and fix all of the amounts.
Answer: I have a fix, but it isn’t a real quick fix, but it is much faster than manually entering hundreds of values. And once you have it set up in your Word options, you just have to remember to select the correct conversion for all formatting to convert properly. Follow the steps below for Word 2007/2010.
- The most important step is to change your Word options (File > Options) Click Advanced and in the General settings place a check mark on “Confirm File Format conversion on Open” and click OK.
- You must re-create your merge file (I prefer to use the Mail Merge Wizard pane under Mailings > Start Mail Merge).
- Indicate your document type and click Next. of and browse for your Excel file to select.
- You will be prompted with a screen “Confirm Data Source” with OLE DB database files. Do NOT select this. Instead, check Show All, which will display several data sources.
- Scroll to select MS Excel Worksheets via DDE (*.xls) and the entire spreadsheet or a specific spreadsheet if the workbook contains more than one.
- You’ll see your columns display (not necessarily in the same order as it was in Excel) and the currency format (as well as other cell formatting) should be retained.
- Continue your mail merge.
For help with general mail merge steps, go to Microsoft free online training. http://office.microsoft.com/en-us/word-help/mail-merge-i-use-mail-merge-for-mass-mailings-RZ010277841.aspx?CTT=5&origin=HA010215566