A
A. Smart
Good Afternoon,
I have a command button that when clicked passes information from a list box
(with 4 columns) to bookmarks in a blank Word template. This works fine but I
only get the contents of the row I've clicked on, whereas I would like to
insert all rows displayed in the list box.
How would I accomplish this?? Thanx in Advance
Code for passing list box (Parts_List) to Word doc:
.ActiveDocument.Bookmarks("PartDesc").Select
.Selection.Text = (CStr(Me.Parts_List))
.ActiveDocument.Bookmarks("Four").Select
.Selection.Text = (CStr(Me.Parts_List.Column(1)))
.ActiveDocument.Bookmarks("Six").Select
.Selection.Text = (CStr(Me.Parts_List.Column(2)))
.ActiveDocument.Bookmarks("PartNo").Select
.Selection.Text = (CStr(Me.Parts_List.Column(3)))
.Activate
I have a command button that when clicked passes information from a list box
(with 4 columns) to bookmarks in a blank Word template. This works fine but I
only get the contents of the row I've clicked on, whereas I would like to
insert all rows displayed in the list box.
How would I accomplish this?? Thanx in Advance
Code for passing list box (Parts_List) to Word doc:
.ActiveDocument.Bookmarks("PartDesc").Select
.Selection.Text = (CStr(Me.Parts_List))
.ActiveDocument.Bookmarks("Four").Select
.Selection.Text = (CStr(Me.Parts_List.Column(1)))
.ActiveDocument.Bookmarks("Six").Select
.Selection.Text = (CStr(Me.Parts_List.Column(2)))
.ActiveDocument.Bookmarks("PartNo").Select
.Selection.Text = (CStr(Me.Parts_List.Column(3)))
.Activate