VBA - MailMerge & Data Form

[PRegis08]

Hi. I am trying to create a userform that will work as a data form. I have
three separate Word templates that will require the same information (name,
address etc.) and I would like the userform to allow them to enter in that
specific information and also choose which of the three templates it would
apply to. There will be a number of letters that will need to be printed so
is there a way to also have it spool the information so the user can print in
batches?

I am pretty familiar with PowerPoint VBA but this is the first time I've
tried word. Can someone point me in the right direction? Thank you in
advance.

Patrick

 

[Doug Robbins - Word MVP]

I am not quite sure what you mean by "spool the information so that the user
can print in batches", but if it is what I think it is, I would have a
series of textbox controls into which the individual pieces of information
for a document would be entered and a command button, which when clicked
would transfer the data from the controls to a listbox on the userform,
before clearing the data out of the textbox controls so that new data could
be inserted into them and the process be repeated. You would also have
buttons to allow you to delete a record from the listbox or to populate the
textbox controls with the data from a record so that it could be edited.
You would also have a checkbox on the userform for each of the templates
that you may want to use as the basis for the documents.

Then you would have another command button which when clicked would iterate
through the records in the listbox, creating each of the required documents,
populated with the data from the records in the listbox.

To get started, see the following pages of fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP