Joined
·
589 Posts
Hi Dreamboat and XLGuru.
A while ago I posted a request for help with getting addresses into Word that were held in an Excel s/s. (s/s is a list of names and addresses, 1 address per row, coulumns = address lines.
(WinXP and OfficeXP).
You both gave me some approaches but I've been chasing some other problems so have only gotten back around to this just now.
This may now be of use to others as I think I have a working solution!
Mail Merge in Office XP isn't immediately as user friendly as in t'old days but Dreamboat's stuff removes some of the mysticism.
Anyway, this appears to work.
1. Set up a Word Template that is a Mail Merge document using the Excel s/s as source.
Enter the name and address lines as merge fields (what a pain in XP as the Address Block doesn't suit UK style addresses!!).
2. When you want to write a new letter and get the required address from the s/s:
A. File / New and select the above template as the document basis.
B. With the Mail Merge toolbar visible, click on the binoculars to open the 'Find Entry' window.
C. Type in the name or membership no or key that you use to select an address row from your s/s. and CANCEL.
d. ??? this doesn't look to change the open document at all, nor does it look as if anything has happened, however:
e. Now press the View Merged Data buitton on the Mail Mege Tioolbar (<<ABC>>),
and dah dah...
f. The required name and address magically appears in a new document and off you go to edit / save / print it etc.
The only 'problem' I have is that if you open WORD and are doing the above and then also want to open the s/s then Excel tells you that the s/s is locked for editing by someone else , but it works fine if the s/s was already open when you then secondly start the merge.
I'm now looking at a nice macro to do the above steps from one button press, but it seems to halt on the Find Entry window.
A while ago I posted a request for help with getting addresses into Word that were held in an Excel s/s. (s/s is a list of names and addresses, 1 address per row, coulumns = address lines.
(WinXP and OfficeXP).
You both gave me some approaches but I've been chasing some other problems so have only gotten back around to this just now.
This may now be of use to others as I think I have a working solution!
Mail Merge in Office XP isn't immediately as user friendly as in t'old days but Dreamboat's stuff removes some of the mysticism.
Anyway, this appears to work.
1. Set up a Word Template that is a Mail Merge document using the Excel s/s as source.
Enter the name and address lines as merge fields (what a pain in XP as the Address Block doesn't suit UK style addresses!!).
2. When you want to write a new letter and get the required address from the s/s:
A. File / New and select the above template as the document basis.
B. With the Mail Merge toolbar visible, click on the binoculars to open the 'Find Entry' window.
C. Type in the name or membership no or key that you use to select an address row from your s/s. and CANCEL.
d. ??? this doesn't look to change the open document at all, nor does it look as if anything has happened, however:
e. Now press the View Merged Data buitton on the Mail Mege Tioolbar (<<ABC>>),
and dah dah...
f. The required name and address magically appears in a new document and off you go to edit / save / print it etc.
The only 'problem' I have is that if you open WORD and are doing the above and then also want to open the s/s then Excel tells you that the s/s is locked for editing by someone else , but it works fine if the s/s was already open when you then secondly start the merge.
I'm now looking at a nice macro to do the above steps from one button press, but it seems to halt on the Find Entry window.
