Please Help?! Pass list box contents to Bookmarks in Word Document

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top