Home Forums Classifieds Blogs Today's Posts Search Social Groups



  
SIGN-UP
Notices

Glock Talk
Welcome To The Glock Talk Forums.

 
  
Reply
 
Thread Tools Display Modes
Old 09-05-2011, 08:27   #1
pal2511
Senior Member
 
pal2511's Avatar
 
Join Date: Sep 2002
Location: KS
Posts: 5,151
Send a message via AIM to pal2511
Microsoft word software question

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
__________________
Quote:
Every time an officer accepts or receives a warning, someone in GNG poops their pants.
pal2511 is offline   Reply With Quote
Old 09-05-2011, 17:19   #2
Pierre!
NRA Life Member
 
Pierre!'s Avatar
 
Join Date: Jun 2003
Location: Lovin Sparks Nv!
Posts: 4,170
Quote:
Originally Posted by pal2511 View Post
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
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...

Patrick
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures.


Download YOUR copy of
To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures.

My Gift to You, AND it's >FREE<
Pierre! is online now   Reply With Quote
Old 09-05-2011, 19:05   #3
Ogreon
unlisted
 
Join Date: Oct 2006
Posts: 786
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.
Ogreon is offline   Reply With Quote
Old 09-06-2011, 16:17   #4
pal2511
Senior Member
 
pal2511's Avatar
 
Join Date: Sep 2002
Location: KS
Posts: 5,151
Send a message via AIM to pal2511
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.
__________________
Quote:
Every time an officer accepts or receives a warning, someone in GNG poops their pants.
pal2511 is offline   Reply With Quote
Old 09-06-2011, 20:51   #5
Ogreon
unlisted
 
Join Date: Oct 2006
Posts: 786
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.
Ogreon is offline   Reply With Quote

 
  
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT -6. The time now is 14:26.




Homepage
FAQ
Forums
Calendar
Advertise
Gallery
GT Wiki
GT Blogs
Social Groups
Classifieds


Users Currently Online: 1,081
309 Members
772 Guests

Most users ever online: 2,672
Aug 11, 2014 at 2:31