Excel to Word table (and formatting)

**dems** · 11-05-2009, 01:31 PM

Hi,

I am trying to copy data from an excel sheet into a word document, and would like to learn how i could write a macro to save me time by not having to type it in manually.

Each page of the word document is split into a 4 row x 2 column table, and each row of the spreadsheet contains data to be input into 1 of these table's cells. There are 121 rows of data and 4 variables/columns.

Furthermore, the data extracted from the table is to be reformatted, so that it takes a vertical shape inside the cell.
ie. <Info A>
<Info B>
<Info C>
<Info D>

If anyone could assist me or set me in the right direction it would be greatly appreciated, as this is quite far out of my depth.

I have attached the files in case the above doesn't make much sense.

Thx & rgrds,

D

**teylyn** · 11-05-2009, 05:18 PM

Hi,

could you also attach a Word document that shows what the result should look like? Attaching Word documents is a bit painful here, you first have to Zip them, otherwise they're too big.

cheers

**dems** · 11-05-2009, 08:44 PM

Attached word doc as requested.

Hope this helps visualise the problem.

D

**teylyn** · 11-05-2009, 09:06 PM

Dems, what you want to do does not require a macro or complicated copy and paste operations. You need to look into mail merge using Labels as the target document.

In Word, click the Mailings ribbon, then open the "Start Mail Merge panel" and select "Step by step Mail Merge Wizard".
Step 1 - Select document type = Labels
Step 2 - Select Use the current document
Step 3 - click the Browse button and navigate to your Excel file and select the first tab, click ok
Step 4 - use the "More Items" dialog to insert your fields . Arrange the fields on the first label, then click the button "Update all labels" to copy the layout to the other labels
Step 5 - preview the labels
Step 6 - complete the merge, either to a new document (advisable) or straight to the printer (not advisable)

hth