Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Garner, North Carolina, USA
    Posts
    241
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically paste data from one form to another (Word/Office 2000)

    I have two forms/templates that I have set up for our office. They are 1 page in length and both are in the same document as both are always filled out together. A large portion of the information is the same for both forms (name, address, etc). Is it possible to type the information in the first form and have it automatically pasted (paste special ? - I know about it but not really how I would use it) into the second form. Keep in mind that I am working with a password protected template, using form fields, with a locked form. My coworkers will access the document from an Intranet and fill it in from there and print.
    Thanks for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatically paste data from one form to another (Word/Office 2000)

    I'll try to describe two different solutions.

    A. You want the second form to contain exact copies of some form fields in the first form. The user doesn't need to edit the copied information. In this case, you can use cross references.

    While the document is unprotected:
    1. <LI>Double click a form field in the first form.
      <LI>Enter a name in the Bookmark box. Remember this name.
      <LI>Check the "Calculate on exit" check box.
      <LI>Click OK.
      <LI>Go to the location in the second form where you want the information to be copied.
      <LI>Select Insert/Cross-reference...
      <LI>In the first dropdown list, select Bookmark; in the second Bookmark text.
      <LI>In the list of bookmarks, select the name you just assigned to the form field.
      <LI>Check or uncheck the "Insert as hyperlink" check box, according to your preference.
      <LI>Click Insert.
      <LI>Repeat the above for all form fields you want to be copied.
    <img src=/w3timages/blueline.gif width=33% height=2>

    B. You want information to be copied from form fields in the first form to form fields in the second form. The user can edit the copied information. In this case, you need to use macros that will fire on exiting a form field.

    For example: the first form contains a form field with name (=bookmark) FirstName; the second form contains a form field with name (=bookmark) FirstNameCopy.

    Create a macro (in the VB Editor, insert a module into the document)

    Sub CopyFirstName()
    ActiveDocument.FormFields("FirstNameCopy").Result = ActiveDocument.FormFields("FirstName").Result
    End Sub

    While the document is unprotected:
    1. <LI>Double click the FirstName form field.
      <LI>In the dropdown list for the macro to run on exiting the field, select CopyFirstName.
      <LI>Click OK.
    Again, you'll have to repeat this for every form field you want copied.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Garner, North Carolina, USA
    Posts
    241
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically paste data from one form to another (Word/Office 2000)

    Thanks, Hans!
    I used the first solution. What a time saver this will be to us!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •