Hi all,
I wonder if anyone can tell me whether it is possible to pull text from an Extra! session (using, for example, getstring) and then pass that data into a user form in word.
What I have at the moment (and which works fine) is when a client account is opened and a certain action initiated (in this case the sending of a letter), the macro performing that action determines whether the account meets certain criteria (in this case, if there is more than one nominated contact person). If there isn't all actions can be performed within the session and the macro just proceeds. If, however, there is more than one person, then the letter needs to be sent manually. Extra notifies the user of this (by way of a message box) and then launches MS Word, and adds to the word session an appropriate letter.
Separately, on opening that word file creates a new document, and opens a userform which, once completed (this is done manually), insets the entered data into the letter and launches the print dialog/ue.
I wonder, though, if it is possible for Extra to complete the userform based on datas available to it. For example, if the client name appears at 04, 25 and is 5 characters long in Extra can Extra perform getstring(04,25,05) and then auto-complete (if you will) word's (active) userform (by, for example changing the value of the particular textbox - e.g. ActiveDocument.Userform1.Textbox1.Value = "[whatever]" ).
This needs to be done from within extra, rather than on initialization of the userform as the letters are also used independently (and it would be annoying to open it, and then have it try to scrape an extra session and auto complete with data that you never wanted....)
Any help would be much appreciated!
C.
I wonder if anyone can tell me whether it is possible to pull text from an Extra! session (using, for example, getstring) and then pass that data into a user form in word.
What I have at the moment (and which works fine) is when a client account is opened and a certain action initiated (in this case the sending of a letter), the macro performing that action determines whether the account meets certain criteria (in this case, if there is more than one nominated contact person). If there isn't all actions can be performed within the session and the macro just proceeds. If, however, there is more than one person, then the letter needs to be sent manually. Extra notifies the user of this (by way of a message box) and then launches MS Word, and adds to the word session an appropriate letter.
Separately, on opening that word file creates a new document, and opens a userform which, once completed (this is done manually), insets the entered data into the letter and launches the print dialog/ue.
I wonder, though, if it is possible for Extra to complete the userform based on datas available to it. For example, if the client name appears at 04, 25 and is 5 characters long in Extra can Extra perform getstring(04,25,05) and then auto-complete (if you will) word's (active) userform (by, for example changing the value of the particular textbox - e.g. ActiveDocument.Userform1.Textbox1.Value = "[whatever]" ).
This needs to be done from within extra, rather than on initialization of the userform as the letters are also used independently (and it would be annoying to open it, and then have it try to scrape an extra session and auto complete with data that you never wanted....)
Any help would be much appreciated!
C.