P
Phonedude
Here's what I am trying to accomplish. I have several workbooks which
keep track of customers for me. There is a master sheet with a list
of all the customers in the book and each row has a link to that
particular customer's own sheet. I would like to be able to go the
the customer sheet and click an icon and open a Word file, insert data
from particular cells and let me print the letter after reviewing it
in Word. Several different letters, each with their own icon, or
mayby one icon with a letter selection option. Not interested in
saving the letter, but I might add code to the module which notes, on
the sheet, that the letter was sent.
This is *not* a mail merge -- it's one sheet with one customer. The
name, address, and other pertinent information is all on the sheet in
individual cells, but it's not a database.
I've searched and searched and cannot find a clue -- I am not
incompetent in VBS, but I can't find a direction to go in. Can
someone give me a clue?
Open a Word doc, insert data from known cells in the active sheet in
predetermined locations in the doc . . .
Does this make sense and is there a reference I can go to?
Thanks,
Larry
keep track of customers for me. There is a master sheet with a list
of all the customers in the book and each row has a link to that
particular customer's own sheet. I would like to be able to go the
the customer sheet and click an icon and open a Word file, insert data
from particular cells and let me print the letter after reviewing it
in Word. Several different letters, each with their own icon, or
mayby one icon with a letter selection option. Not interested in
saving the letter, but I might add code to the module which notes, on
the sheet, that the letter was sent.
This is *not* a mail merge -- it's one sheet with one customer. The
name, address, and other pertinent information is all on the sheet in
individual cells, but it's not a database.
I've searched and searched and cannot find a clue -- I am not
incompetent in VBS, but I can't find a direction to go in. Can
someone give me a clue?
Open a Word doc, insert data from known cells in the active sheet in
predetermined locations in the doc . . .
Does this make sense and is there a reference I can go to?
Thanks,
Larry