Scotsman71
Programmer
Okay...I'm doing a small project...basically I have a list of my friends addresses. Lets say 20 addresses. Whenever I wish to write them a letter, I have to key it in manually, or manually copy + paste from the text file I have.
I came up with a solution...right now, if I run a macro it will prompt me for the users first name, and it'll look inside the code of the macro to find that name, and copy the lines associated with it and paste it in.
However, I'd like to modify this further. I'd like to have all the addresses in a separate document(txt file probably), and so when I run the macro, it would prompt me for the persons first and last name(as it does now), and then it would look through the text file, locate the name and address, and paste it in. Has anyone seen a macro like this before, or any tips on how to do it? Been having problems executing it.
I came up with a solution...right now, if I run a macro it will prompt me for the users first name, and it'll look inside the code of the macro to find that name, and copy the lines associated with it and paste it in.
However, I'd like to modify this further. I'd like to have all the addresses in a separate document(txt file probably), and so when I run the macro, it would prompt me for the persons first and last name(as it does now), and then it would look through the text file, locate the name and address, and paste it in. Has anyone seen a macro like this before, or any tips on how to do it? Been having problems executing it.
