Microsoft Office Tutorials and References
In Depth Information
Mail Merge: Creating a One-to-Many List
End If¶
IsSecond = Not IsSecond¶
End If¶
Next cel¶
MsgBox "Finished!", vbOKOnly + vbInformation¶
End Sub¶
' * * * * *¶
Function TrimCellText(s As String) As String¶
'Remove end-of-cell markers¶
TrimCellText = Left(s, Len(s) - 2)¶
End Function¶
Follow these steps:
1. Substitute the name of the AutoText entry for the value of Const
2. Set up the main merge document as a catalog-type merge. Save the file
as a template.
3. Create the basic WordArt with some sample text. Select it. Save it as an
AutoText entry in this template. (Use Insert | AutoText | AutoText to
create the entry and be sure to select this template from the list at the
bottom of the dialog box.) Delete it.
4. Set up a table to match the place card paper stock. Insert the merge
fields that will be converted to WordArt into the table cells.
Mail Merge: Creating a One-to-Many List
This procedure lets you create lists of multiple, related items for each data
record in the mail merge result. It demonstrates how to link to Access, gather
data, insert it into Word and format it as a table.
Example file:
Scenario: Word's mail merge feature provides no way to
generate lists of items belonging to a single entry. For
example, a table of grades won't get Word to generate a list
of grades for each pupil without resorting to a very complex
set of nested field codes. Alternatively, mail merge can be
bypassed entirely and the creation of the individual letters
can be programmed in VBA.
Search JabSto ::

Custom Search