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
[TABLE="width: 493"]
<TBODY>[TR]
[TD]NAME</SPAN>[/TD]
[TD]COMMERZBANK</SPAN>[/TD]
[/TR]
[TR]
[TD]Meeting Date&Time</SPAN>[/TD]
[TD]3/19/2011 6:48:08 AM</SPAN>[/TD]
[/TR]
[TR]
[TD]Memo Text 1</SPAN>[/TD]
[TD]Large Text String #1</SPAN>[/TD]
[/TR]
[TR]
[TD]Memo Text 2</SPAN>[/TD]
[TD]Large Text String #2</SPAN>[/TD]
[/TR]
[TR]
[TD]Memo Text 3</SPAN>[/TD]
[TD]Large Text String #2</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]
Here is an Example of the Word File Expected Results:
Name: COMMERZBANK
Meeting Date&Time: 3/19/2011 6:48:08 AM
[TABLE="width: 493"]
<TBODY>[TR]
[TD]Large Text String #1<o></o>
Large Text String #2<o></o>
Large Text String #2
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]
</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
Here is an example of the Spreadsheet
[TABLE="width: 493"]
<TBODY>[TR]
[TD]NAME</SPAN>[/TD]
[TD]COMMERZBANK</SPAN>[/TD]
[/TR]
[TR]
[TD]Meeting Date&Time</SPAN>[/TD]
[TD]3/19/2011 6:48:08 AM</SPAN>[/TD]
[/TR]
[TR]
[TD]Memo Text 1</SPAN>[/TD]
[TD]Large Text String #1</SPAN>[/TD]
[/TR]
[TR]
[TD]Memo Text 2</SPAN>[/TD]
[TD]Large Text String #2</SPAN>[/TD]
[/TR]
[TR]
[TD]Memo Text 3</SPAN>[/TD]
[TD]Large Text String #2</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]
Here is an Example of the Word File Expected Results:
Name: COMMERZBANK
Meeting Date&Time: 3/19/2011 6:48:08 AM
[TABLE="width: 493"]
<TBODY>[TR]
[TD]Large Text String #1<o></o>
Large Text String #2<o></o>
Large Text String #2
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD]
</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]