B
b.z.
I have a database in which I have various client information such as contact
name and address and such. I have created several mail merge documents which
I use to generate letters using my excel database information. I want to
place a command button on a worksheet in excel that will allow me to run a
macro that will open up a specific WORD mail merge file (that I have already
created) that uses the information from my excel sheet and then automatically
fill in the mail merge information and then run a macro that i have already
recorded in the word mail merge file to automate the steps of the mail merge
so that it performs the steps of the mail merge and opens a new word document
with my letters so that I can then review, save and print the mail merged
file. I've been trying to figure out the coding that will allow me to tell
excel to open up a specific word document but i can't seem to get it to work
correctly. Also, I was hoping that I would be able to copy the code from the
macro I recorded in my word mail merge document that lets me automate the
mail merge steps into the macro for the command button. I have next to no
knowledge of visual basic but have figured out how to modify certain codes so
that I can use them for my purposes. This seems like a lot, but reading about
similar things others have done it doesn’t really seem like it should be that
difficult. I do these repetitive tasks everyday, so I’m looking for a
one-touch button to automate the whole process.
Thanks in advance for the help.
name and address and such. I have created several mail merge documents which
I use to generate letters using my excel database information. I want to
place a command button on a worksheet in excel that will allow me to run a
macro that will open up a specific WORD mail merge file (that I have already
created) that uses the information from my excel sheet and then automatically
fill in the mail merge information and then run a macro that i have already
recorded in the word mail merge file to automate the steps of the mail merge
so that it performs the steps of the mail merge and opens a new word document
with my letters so that I can then review, save and print the mail merged
file. I've been trying to figure out the coding that will allow me to tell
excel to open up a specific word document but i can't seem to get it to work
correctly. Also, I was hoping that I would be able to copy the code from the
macro I recorded in my word mail merge document that lets me automate the
mail merge steps into the macro for the command button. I have next to no
knowledge of visual basic but have figured out how to modify certain codes so
that I can use them for my purposes. This seems like a lot, but reading about
similar things others have done it doesn’t really seem like it should be that
difficult. I do these repetitive tasks everyday, so I’m looking for a
one-touch button to automate the whole process.
Thanks in advance for the help.