Originally Posted by pal2511
I have Microsoft Office 2007. In my reports I have fields that I put peoples name, address and so on in. Then I type my normal narrative. Then I have another document that I put the same thing in such as name, address and so on. Is there a way to make a macro or database to import all the information from one document to the other easily?
I already have a macro template setup for my other files. I know its hard to explain. If anyone can help I would appreciate it. Right now I just retype it all but I would like to import it to save some time and IF possible be able to save all the information in a database for future reference. I know I will use the same information more than once in the future
Two forms that do the same thing??? Uhm... Forgive me but I have to ask - WHY?
I am sure there is a procedure or policy about this, but duplicating effort is a budget killer in the long run, not to mention that the information degrades every time it is 'duplicated'...
If there is a chance that you can simply change the name of the file when you save it, then rename the 'Form Name' even that would be better...
Hope that makes sense, but I always have to ask why folks are requested to duplicate infomation into 2 different 'forms' or 'documents'.
*Handle It Once* - THAT is the *best* of the Best Practices!
Feel free to fire back with more detail, and I'll be checking back after dinner...