B
ben
I still need help with mail merge and userforms:
How can I tell word to merge a template and then have a
user form pop up to fill in missing information:
1. I am merging data from a database into a fax or
tranmittal or letter template (like the name of the
person, fax number, address etc) I am using one contact
per merge (or several for a multi recipient fax cover
sheet), thus just creating one form per merge.
This part of the process works very well. the database
program opens up the word template and creates a new
document with the merged info. I also inserted fill-ins to
fill out the rest of the data like job number, number of
pages etc. Before the new document is created, the fill-
ins prompts the user to fill in missing info one at
a time.(line job number, then job name then... So far so
good.
2. I would like to consolidate all the fill-ins into one
userform, that allows me to add drop down menus, and check
boxes (let's say there is a check box saying 'urgent', the
userform would fill this into the fax document) as well
as other information and program it to restrict users to
go over 20 characters etc. etc.
How can I make the userform pop up after/while I perform
mail merge just like the fill-ins? I wasn't able to do it
yet, but I guess I need a macro that says something like
show userform1 before creating mail merge? A macro
called 'autonew' and says 'userform1.show' didn't do the
job, that only works without mail merge.
Thank you so much for your help,
Ben
--
How can I tell word to merge a template and then have a
user form pop up to fill in missing information:
1. I am merging data from a database into a fax or
tranmittal or letter template (like the name of the
person, fax number, address etc) I am using one contact
per merge (or several for a multi recipient fax cover
sheet), thus just creating one form per merge.
This part of the process works very well. the database
program opens up the word template and creates a new
document with the merged info. I also inserted fill-ins to
fill out the rest of the data like job number, number of
pages etc. Before the new document is created, the fill-
ins prompts the user to fill in missing info one at
a time.(line job number, then job name then... So far so
good.
2. I would like to consolidate all the fill-ins into one
userform, that allows me to add drop down menus, and check
boxes (let's say there is a check box saying 'urgent', the
userform would fill this into the fax document) as well
as other information and program it to restrict users to
go over 20 characters etc. etc.
How can I make the userform pop up after/while I perform
mail merge just like the fill-ins? I wasn't able to do it
yet, but I guess I need a macro that says something like
show userform1 before creating mail merge? A macro
called 'autonew' and says 'userform1.show' didn't do the
job, that only works without mail merge.
Thank you so much for your help,
Ben
--