[Arthur Menu]

I have a Word document that contains a table. I have inserted comments on
some of the text in some of the cells. When I do a mail merge with this
documnt as the data source to create a sheet of address labels, the index
numbers of the comments appear on the label. For example, if I have a comment
with the index "[AM1]", then "[AM1]" appears on the label. This happens even
when I have changed the options of the document so that the indices do not
appear on the screen when viewing the document. How do I print labels that do
not have this unwanted text?
-- Arthur

[Graham Mayor]

It seems that comments are transferred when you merge. Merge to a new
document and either delete the comments or from the review toolbar turn off
their display and then print that document.
OR
Make a copy of the table document and use the following macro to delete all
the comments, then use that as a data source.

Sub DeleteComments()
Dim i As Long
For i = ActiveDocument.Comments.Count To 1 Step -1
ActiveDocument.Comments(i).Delete
Next i
End Sub

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Arthur Menu wrote:
I have a Word document that contains a table. I have inserted
comments on some of the text in some of the cells. When I do a mail
merge with this document as the data source to create a sheet of
address labels, the index numbers of the comments appear on the
label. For example, if I have a comment with the index "[AM1]", then
"[AM1]" appears on the label. This happens even when I have changed
the options of the document so that the indices do not appear on the
screen when viewing the document. How do I print labels that do not
have this unwanted text? -- Arthur

[Arthur Menu[_2_]]

Hi Graham,

Thank you for your helpful advice. I have copied the macro into my normal
template for use as needed. To clarify my original post, it is not the
comments in their entirety that are transferred when I merge, but only the
indices of each comment. They appear as simple text in the merged document.
So the review toolbar doesn't help. It seems to me that this must be a bug in
the MS software. My workstation is part of a large organization whose IS
department keeps our equipment and software up to date, so I don't think the
fault lies with us.

Arthur

"Graham Mayor" wrote:

It seems that comments are transferred when you merge. Merge to a new
document and either delete the comments or from the review toolbar turn off
their display and then print that document.
OR
Make a copy of the table document and use the following macro to delete all
the comments, then use that as a data source.

Sub DeleteComments()
Dim i As Long
For i = ActiveDocument.Comments.Count To 1 Step -1
ActiveDocument.Comments(i).Delete
Next i
End Sub

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Arthur Menu wrote:
I have a Word document that contains a table. I have inserted
comments on some of the text in some of the cells. When I do a mail
merge with this document as the data source to create a sheet of
address labels, the index numbers of the comments appear on the
label. For example, if I have a comment with the index "[AM1]", then
"[AM1]" appears on the label. This happens even when I have changed
the options of the document so that the indices do not appear on the
screen when viewing the document. How do I print labels that do not
have this unwanted text? -- Arthur