Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion of Excel to Word
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion of Excel to Word
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. -- Kevin Backmann "vchild38" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion of Excel to Word
Can I just copy the info from excel to word, will the excel format still hold?
"Kevin B" wrote: 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. -- Kevin Backmann "vchild38" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion of Excel to Word
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... -- Kevin Backmann "vchild38" wrote: Can I just copy the info from excel to word, will the excel format still hold? "Kevin B" wrote: 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. -- Kevin Backmann "vchild38" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion of Excel to Word
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. "Kevin B" wrote: 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... -- Kevin Backmann "vchild38" wrote: Can I just copy the info from excel to word, will the excel format still hold? "Kevin B" wrote: 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. -- Kevin Backmann "vchild38" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion of Excel to Word
As Abby says, simply CopyPaste converts Excel data to Word Tables and you
edit using the Word table options. CopyPaste Special, Microsoft Office Excel Worksheet Object embeds Excel in Word. Same as InsertObjectCreate 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. "Abby" wrote: 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. "Kevin B" wrote: 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... -- Kevin Backmann "vchild38" wrote: Can I just copy the info from excel to word, will the excel format still hold? "Kevin B" wrote: 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. -- Kevin Backmann "vchild38" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Batch conversion of many word.docs to PDF | Excel Discussion (Misc queries) | |||
word pad file conversion to excel sheet | Excel Worksheet Functions | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Word to Excel format conversion? | Excel Discussion (Misc queries) |