На просторах сети есть такой
вариант:
[code h=150]'' тип 2
''From: My Company, Inc
''Index:12345
''Address:1260, Universal st., Arivo, Mexico
'' Your advertising can be here
''
''
'' To:
'' Index
''Address:
Sub m101119_0827()
Dim s1, s2, j1, j2, j3, j3k
s1 = Excel.ActiveWorkbook.Path
Dim ws As Worksheet
Set ws = Excel.ActiveSheet
'ФОРМИРОВАНИЕ ФАЙЛА ДЛЯ WORD
'---------------по типу конверта
'---------------при необходимости требуемое количество копий
'---------------можно добавить дату для уникальности имени
'можно сразу указать размер бумаги и ориентацию
'достаточно точно расположить from \to
s2 = s1 & "\k" & ws.Range("e1") & ".doc"
Open s2 For Output As #1
Print #1, "<html>"
Print #1, "<meta http-equiv=""Content-Type"" content=""text/html; charset=windows-1251"">"
j1 = 1
j2 = 0
Do While j2 < 1000 And j1 < 65000
j1 = j1 + 1
If ws.Cells(j1, 5) = ws.Cells(1, 5) Then
j3 = 0
j3k = IIf(ws.Cells(j1, 4) & "" = "", 1, ws.Cells(j1, 4))
Do While j3 < j3k
j3 = j3 + 1
j2 = j2 + 1
Debug.Print j1, j2, j3
If j2 > 1 Then
Print #1, "<p align=right><font color=red>-"; Chr(12), j2; "</FONT></P>"
End If
Print #1, "<table border=0>"
Print #1, "<tr>"
Print #1, "<th align=right>From:"
Print #1, "<td colspan=2>My Company, Inc"
Print #1, "<tr>"
Print #1, "<th align=right>Index:"
Print #1, "<td>12345"
Print #1, "<tr>"
Print #1, "<th align=right>Address:"
Print #1, "<td colspan=2>1260, Universal st., Arivo, Mexico"
Print #1, "<tr>"
Print #1, "<th "
''''''''''''''''''''''''''''''''
Print #1, "<tr>"
Print #1, "<td> "
Print #1, "<tr>"
Print #1, "<td> "
Print #1, "<th align=right>To:"
Print #1, "<td >"; ws.Cells(j1, 1)
'''''''''''''''''''''''''''''''''''
Print #1, "<tr>"
Print #1, "<td>"
Print #1, "<th align=right>Index:"
Print #1, "<td>"; ws.Cells(j1, 2)
Print #1, "<tr>"
Print #1, "<td>"
Print #1, "<th align=right>Address:"
Print #1, "<td >"; ws.Cells(j1, 3)
Print #1, "</table>"
Loop
End If
Loop
Close #1
End Sub[/code]