I have my database in excel2007 and it has to be merged to word2007(i am
familiar with mailmerge)
how can i automate selection of a field (in excel) by pressing a button(or
macro) on the word document
example
when i press the button or run macro in word the following actions are
completed in one go
--a field in excel is selected(say COUNTRY)
--then in that field a particular sub-field is selected(SAY JAMAICA)
--the merge is completed in word docu
--blank rows in the word document get deleted
--the word print command pops up
similarly if i press another button or run another macro
i can select any other country say iran or india
or--another idea is that a list box popsup with all the names available
under the country field and i simply select a country and the sequence of
merge and print starts
familiar with mailmerge)
how can i automate selection of a field (in excel) by pressing a button(or
macro) on the word document
example
when i press the button or run macro in word the following actions are
completed in one go
--a field in excel is selected(say COUNTRY)
--then in that field a particular sub-field is selected(SAY JAMAICA)
--the merge is completed in word docu
--blank rows in the word document get deleted
--the word print command pops up
similarly if i press another button or run another macro
i can select any other country say iran or india
or--another idea is that a list box popsup with all the names available
under the country field and i simply select a country and the sequence of
merge and print starts
