Macro to Copy Data from Excel to Word for Printing

[Rallybas]

I have some basic information in Excel. It captures call information. There are 3 large fields that contain the “memos”. I want all the information from Excel to Word in order to print them out. I have the first part of the macro created which transposes the row to column. I am having trouble with the main part of the macro which is supposed to copy from Excel to Word. Whenever I try and run the macro, it does not execute the copy into word. What am I missing? This should be simple. Thanks.</SPAN>

Here is an example of the Spreadsheet

NAME</SPAN>	COMMERZBANK</SPAN>
Meeting Date&Time</SPAN>	3/19/2011 6:48:08 AM</SPAN>
Memo Text 1</SPAN>	Large Text String #1</SPAN>
Memo Text 2</SPAN>	Large Text String #2</SPAN>
Memo Text 3</SPAN>	Large Text String #2</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>

Here is an Example of the Word File Expected Results:
Name: COMMERZBANK
Meeting Date&Time: 3/19/2011 6:48:08 AM

Large Text String #1<o></o> Large Text String #2<o></o> Large Text String #2	</SPAN>
</SPAN>	</SPAN>
</SPAN>	</SPAN>
</SPAN>	</SPAN>
</SPAN>	</SPAN>

<TBODY>
</TBODY>