Conversion of Excel to Word

[Guest]

I have the Trial Microsoft 2007, on on of the excell files I want to convert
the spreadsheet (Names and addresses) to word (2007) to labels.

 

[Guest]

It's not really a conversion, its a mail merge, where Excel is the data
source and Word provides the label template.

If you've not done a merge before I would suggest that you try the Microsoft
Word forum for some assistance regarding a Word/Excel Mail merge.

 

[Guest]

Can I just copy the info from excel to word, will the excel format still hold?

 

[Guest]

While you can copy your Excel data and paste it into a Word document you
would have to do some work to format the data to print on labels, not
impossible necessarily, but not a straight forward copy/paste.

When you copy data from Excel and paste it into Word the Excel data is
pasted as a table. Since Word uses tables to layout label grids you could
then format the table to conform to the dimensions of the label you want to
use.

On the other hand, doing a mail merge lets you select the Avery label size
you wish to print, Word dimensions the table accordingly, and all you have to
do is place the merge fields in the order that you want them to appear on the
label.

Personally, I would do the merge. Word's help facility will provide you
with enough information to get started and you can google Word Mail Merge
labels, or something along those lines, and get more on-line help than you
could ever want.

Good luck...

 

[Abby]

Kevin,
Copy the info that you need from Excel. Go to your blank Word document,
click on Edit. Pick Paste Special. From there, select Microsoft Office
Excel Worksheet Object. Click OK. You should have your Excel doc in Word
format. Anytime you have formatting issues, it's my understanding that you
cannot do an ordinary Paste. Instead, you can keep your formatting by using
the Paste Special function. Hope this helps.

 

[cmarion]

As Abby says, simply Copy>Paste converts Excel data to Word Tables and you
edit using the Word table options.

Copy>Paste Special, Microsoft Office Excel Worksheet Object embeds Excel in
Word. Same as Insert>Object>Create from file. Choose "Link to file" to update
original Excel file when changes are made. When you double click the Excel
Object, the Excel toolbars appear and you edit in Excel. Therefore the data
is not converted to Word, but Word now accesses Excel for editing.