Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2012, 05:45 AM
Greenhorn Greenhorn is offline how do I auto-populate a word template Windows Vista how do I auto-populate a word template Office 2007
Novice
how do I auto-populate a word template
 
Join Date: Sep 2012
Posts: 3
Greenhorn is on a distinguished road
Default how do I auto-populate a word template

I have a word template that I use for customers.
I am trying to find a way to have this template auto populate, from information I already have stored in an Access DB.
Example: If I type a primary key into a box, let's say customer ID.
The rest of the template would auto populate with that customers information I already have stored in my Access DB.
Thank you in advance,
Reply With Quote
  #2  
Old 09-05-2012, 11:22 AM
Charles Kenyon Charles Kenyon is offline how do I auto-populate a word template Windows Vista how do I auto-populate a word template Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,932
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

It is called Mail Merge and works in all versions of Word since Word 97 at least. I recall using it in Word 3.

Once you've attached your database to your document, you use the "find recipient" button to find your data record. It populates the fields in your document (which you inserted as merge fields) automatically.

Once you have this done, under the Start Merge button you select Normal Word document so that future changes to the database will not change this document.

You start with a Template that holds your merge fields in appropriate places. Have it attached to your database and save it. When you create a new document from the template it will ask if you want this connection to continue. Then under the mailings tab you use the find recipient command.
Reply With Quote
  #3  
Old 09-05-2012, 11:42 AM
Greenhorn Greenhorn is offline how do I auto-populate a word template Windows Vista how do I auto-populate a word template Office 2007
Novice
how do I auto-populate a word template
 
Join Date: Sep 2012
Posts: 3
Greenhorn is on a distinguished road
Default

Yes that would work,
However I kind of want my customers to use the template.
And that would be to much work.

Is there a way to have a log-in function that would then auto-populate the template? Based on their Unique ID
Reply With Quote
  #4  
Old 09-05-2012, 01:33 PM
Charles Kenyon Charles Kenyon is offline how do I auto-populate a word template Windows Vista how do I auto-populate a word template Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,932
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

Quote:
Originally Posted by Greenhorn View Post
Yes that would work,
However I kind of want my customers to use the template.
And that would be to much work.

Is there a way to have a log-in function that would then auto-populate the template? Based on their Unique ID
Is it possible? Yes.

Can it be done with a built-in Word function without programming? No.

Is such programming trivial? No. Not in this case. You would want to not only allow the customer to populate it, but also to protect your database from them getting everyone else's data.

This is better handled from the Access end. It could generate merge with a Word template and fill in the information. I do not know how to do that, but believe it would be much easier than trying to protect your database from Word's end.
Reply With Quote
  #5  
Old 09-05-2012, 04:16 PM
Greenhorn Greenhorn is offline how do I auto-populate a word template Windows Vista how do I auto-populate a word template Office 2007
Novice
how do I auto-populate a word template
 
Join Date: Sep 2012
Posts: 3
Greenhorn is on a distinguished road
Default

That's what I was afraid off, but you hit the nail on the head as far as security is concerned. Damn I wish I knew more about programming.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I auto-populate a word template Auto-populate content across slides Thinker PowerPoint 1 02-20-2012 05:26 AM
Auto populate a word document anadmin Word 0 08-05-2011 07:47 AM
Auto populate text help i'm stuck! Word 1 08-13-2010 11:52 AM
auto populate to a PDF file jerrymbna22 Excel 0 07-12-2010 02:19 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft