Turning A Table Into A Calendar; Word 2010

What is the best way to embed Excel data into Word?

In the latest version of Microsoft Office for Windows, if you copy/paste a table from Excel into Word, it automatically breaks the link and translates the data into Word's proprietary table format...thus losing a lot of abilities that Excel has.If you would prefer the OLD format of "OLE Embedding," you can still do that, though it's not really recommended. Instead of clicking paste, click the arrow under paste on the ribbon (toolbar). Choose "paste special," and then choose "Microsoft Excel Worksheet Object."Other than that, you can also choose different paste style formatting options by hovering over the mini-bar (the little icon that appears after you paste something) to choose different styling choices.

When I copy a small table from Excel and paste it into Gmail while composing an email, why do I lose the table format?

If you are using the Chrome browser, you will lose your table format. You have two options to try: 1. use another browser, like Internet Exploreror Firefox. 2. copy the spreadsheet first to Microsoft Word. Make sure it looks right in Word. Then make sure your Gmail is using rich text format. You do thatby checking the formatting bar at the bottom of the message window where you are typing your email. On the right side of the bar, the words "Plain text"will be shown if it is plain text. If it is rich text,the area on the right side of the bar will be blank.Finally, copy the spreadsheet from Word to Gmail. The formatting should be maintained in Gmail. Here is a link to a Google forum where this is discussed:https://productforums.google.com...Good luck!

How can I populate a Word template with data from Excel?

What you want to do is called Mail Merge. The tool was originally created for form letters, hence the name. But it can be used to create any type of Word document where data is taken from an Excel worksheet and then inserted into a Word template.The starting point is an Excel worksheet with header labels in row 1 and data to be used in the Word document in columns underneath. Each row in the Excel worksheet corresponds to a separate Word document.Then in the Word document, you will use the Mailings tab on the ribbon to modify your template so it can accept data from the Excel workbook. Click the Start Mail Merge icon on the ribbon, and then choose Step by Step Mail Merge Wizard… to start the process. This will guide you through the process of linking the Excel workbook, inserting merge fields into your Word template to receive data from Excel, and then creating documents. I suggest testing with just a few rows of data from the Excel workbook, because you may want to make some changes after seeing the results.An illustrated guide to the Mail Merge process may be found at How to Perform a Mail Merge in Word 2010