Solved convert Excel to Word

August 9, 2010 at 14:43:56
Specs: Windows 7
How can I convert excel into word

See More: convert Excel to Word

Report •


✔ Best Answer
August 10, 2010 at 05:03:23
Hi,

Mail merge sounds like the Word 'function' you need.

It allows you to setup a document using named fields, and these named fields are drawn from a data source, such as Excel.

If your Excel worksheet has a series of 'fields' i.e. columns containing:
Courtesy title
First name
Last name
Address1
Address2
Town
Province/State/County
Postal/Zip code
Country
Select the range of cells containing your address data including a headings row as suggested above.

In the address box in Excel - the area just above the column letter A and the Row number 1, which displays the active cell address, type in a name for the table, e.g. Wedding Addresses. Click OK (you must click OK with the cursor still in the address box). Save the Excel file.

In Word use Help to find the Mail Merge Menu/ Mail Merge Helper (I don't have Word 2007 on this PC, so I can't give you the steps) and use the Mail Merge Helper to step you through the process.
It will allow you to link directly to the range you named ("Wedding Addresses") in your Excel Workbook and to map Word's address fields to your headings, and then print a series of envelopes.

Regards



#1
August 9, 2010 at 15:32:06
You're going to have to provide a few more details.

Obviously you know that "Excel" and "Word" are 2 different applications within the Office Suite and that one can not be converted into the other.

I assume you mean something like:

"How can I convert Excel data into Word data?"

Or

"How can I convert an Excel document into a Word document?"

Please give us some more details.


Report •

#2
August 9, 2010 at 16:48:33
My apologies !!! .... you are correct !
I am looking to convert Excel data into Word data !
I have a list of addresses of people ( in Excel ) I am inviting to my daughters wedding and want to send out our invitation to them.
I need to prepare the envlopes ( in Excel !!! ) for the invitation.
I need assistance in how to prepare the envelopes on Word.
I hope I have explained myself correctly in order to get help !!
Thanks to anyone who can guide me thru this.

Ed Varley
.


Report •

#3
August 9, 2010 at 19:07:33
You should look at the Word Help files for Mail Merge.

Mail Merge will allow you to print the envelopes using the data in a Excel spreadsheet without the need to convert anything.

Review the Help files or Google around for a tutorial. Come on back if you need specific help.

If you need to rearrange the Excel file to get it laid out the way Word wants it to be, we may be able to offer some assistance. Not everything has to be done manually.

P.S. Congratulations!


Report •

Related Solutions

#4
August 10, 2010 at 05:03:23
✔ Best Answer
Hi,

Mail merge sounds like the Word 'function' you need.

It allows you to setup a document using named fields, and these named fields are drawn from a data source, such as Excel.

If your Excel worksheet has a series of 'fields' i.e. columns containing:
Courtesy title
First name
Last name
Address1
Address2
Town
Province/State/County
Postal/Zip code
Country
Select the range of cells containing your address data including a headings row as suggested above.

In the address box in Excel - the area just above the column letter A and the Row number 1, which displays the active cell address, type in a name for the table, e.g. Wedding Addresses. Click OK (you must click OK with the cursor still in the address box). Save the Excel file.

In Word use Help to find the Mail Merge Menu/ Mail Merge Helper (I don't have Word 2007 on this PC, so I can't give you the steps) and use the Mail Merge Helper to step you through the process.
It will allow you to link directly to the range you named ("Wedding Addresses") in your Excel Workbook and to map Word's address fields to your headings, and then print a series of envelopes.

Regards


Report •


Ask Question