close

Privacy guaranteed - Your email is not shared with anyone.

Welcome to Glock Talk

Why should YOU join our Glock forum?

  • Converse with other Glock Enthusiasts
  • Learn about the latest hunting products
  • Becoming a member is FREE and EASY

If you consider yourself a beginner or an avid shooter, the Glock Talk community is your place to discuss self defense, concealed carry, reloading, target shooting, and all things Glock.

Microsoft word software question

Discussion in 'Tech Talk' started by pal2511, Sep 5, 2011.

  1. pal2511

    pal2511

    3,980
    0
    Sep 15, 2002
    KS
    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 :)

    Thanks
     
  2. Pierre!

    Pierre! NRA Life Member

    3,965
    139
    Jun 20, 2003
    Lovin Sparks Nv!
    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... :cool:

    Patrick
     


  3. Ogreon

    Ogreon unlisted

    776
    0
    Oct 3, 2006
    It's been a while, but if you're wanting to reuse names and addresses you should be able to put them in Access or Excel and then use the mail merge option to enter the info.
     
  4. pal2511

    pal2511

    3,980
    0
    Sep 15, 2002
    KS
    I am using at least two different forms because they are not all used at once. I only use the 2nd form if I want to pursue charges against someone. The first form is just for information. I would like to keep it in a database that I can personally access later on if i need to contact the person again or if someone else needs to contact them. Since usually most of the people I deal with don't keep a landline its a bit harder to telephone them.
     
  5. Ogreon

    Ogreon unlisted

    776
    0
    Oct 3, 2006
    I keep that information in an Excel spreadsheet with the information separated into individual cells (First Name, Last Name, Street Address, City, State, Zip Code, Phone Number) with each person being a separate line. When I didn't need to send a mailing to every person on the list, I deleted the extraneous lines, saved to a new file, and printed the letter with mail merge pulling the information from the Excel file.

    If I was only sending out one letter, I often just opened the Excel file and pasted the information over into the letter. A database file might have been more flexible, but I would have had to learned to use Access. For this simple usage it seemed easier to simply use Excel.