Re: Trying to automate data entry in word

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

One thing you can consider is to use ASK fields only and put them all at the beginning, nested inside an IF field:

{ IF firsttime = 1 "{ ASK bookmarka "prompt..." }{ ASK bookmarkb "prompt..." }etc." }{ SET firsttime 0 }

But before you save the doc, change that final 0 to 1, execute the SET field, then change the value back to 0

When the user opens the document, they have to know to do ctrl-A then F9. The ASK fields should execute and all REFs (In the main body of the document) that refer to their bookmarks should then be updated. firsttime is set to 0 so the nect time the user does ctrl-A, F9, no ASK fields are executed.

To re-execute the ASKs the user would either have to know how to modify that firsttime value again, then do ctrl-A, F9

I've never actually done it that way (I think it's better to use a userform to set either bookmarks, document variables, or document properties) and it requires more user knowledge than I'd prefer to rely on, but it doesn't need any macros and is perhaps worth a try.

Peter Jamieson
"piersonal" <piersonal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AF91826A-358A-4D29-A968-562A2E0D4AC2@xxxxxxxxxxxxxxxx
I am trying to assemble a template doc so that when a new document is created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!

One idea I had was to have a non printing page at the beginning containing a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not a
big VB man, so hoping it doesn't come to that!!!

.

Relevant Pages

  • Re: Trying to automate data entry in word
    ... But before you save the doc, change that final 0 to 1, execute the SET ... When the user opens the document, they have to know to do ctrl-A then F9. ... document) that refer to their bookmarks should then be updated. ... I've never actually done it that way (I think it's better to use a userform ...
    (microsoft.public.word.docmanagement)
  • CursorLocation playing havoc with search attempts!!
    ... However, as the queries are often executed on a customer table with greater then 50,000 records we use a 2 step process to show the entire customer records. ... To execute a Seek as you know you need a cursorlocation of clUseServer. ... Any ideas on how we can use a Seek on the table to find the record we want, then change the cursor location to clUseClient before we display the data and still record the position of the record we want?? ... We've tried bookmarks, but the bookmark is not preserved when you need to close the table connection to reset the cursor location. ...
    (borland.public.delphi.database.ado)
  • Re: copy a whole one page document and do sth, then paste it back to the end of it
    ... Maybe you should be using mailmerge and execute the merge to a ... > I have a one page document with bookmarks on it. ... > replacement of those bookmarks once. ...
    (microsoft.public.word.vba.general)
  • Re: [kde] Add "enter" to bookmark in Konsole
    ... hit the enter key after each bookmark to execute it. ... appending \n to the lines, ... configure Konsole to hit Enter after a bookmark is selected? ... I extensively use bookmarks for SSH connections ...
    (KDE)