G
Guest
I have been asked to create a word document / template that can be used to
send reports to our customers. This document contains property specific
details and generic paragraphs.
The specifics will be entered via manual typing or merged from our CRM
package Superoffice.
What I would like is a quick way that standard paragraphs can be entered
from a file that is stored on the server. I know that you could use Autotext
but this needs to be used over a network by multiple users occasionally. My
thought process would be to have a macro on a toolbar that pops up a question
that says "what code". The user enters the code which relates to a
paragraph(s) of text that is then looked up from a central file stored on the
server (which could be a word document / excel spreadsheet) and inserted into
the word document.
i.e.
What Code?: Code2
Looks up file: \\server\codes.doc
Code: Returned Text for code:
~~~~~ ~~~~~~~~~~~~~~~~~~~~~
Code1 Standard paragraph text 1
Code2 Standard paragraph text 2
Code3 Standard paragraph text 3
Returns text "Standard paragraph text 2"
Reason for a central document is that text is changed on regular basis for
offers or legal updates.
I am sure (hope) that the answer is quite simple - but haven’t got much more
hair left to pull out! - Thanks
send reports to our customers. This document contains property specific
details and generic paragraphs.
The specifics will be entered via manual typing or merged from our CRM
package Superoffice.
What I would like is a quick way that standard paragraphs can be entered
from a file that is stored on the server. I know that you could use Autotext
but this needs to be used over a network by multiple users occasionally. My
thought process would be to have a macro on a toolbar that pops up a question
that says "what code". The user enters the code which relates to a
paragraph(s) of text that is then looked up from a central file stored on the
server (which could be a word document / excel spreadsheet) and inserted into
the word document.
i.e.
What Code?: Code2
Looks up file: \\server\codes.doc
Code: Returned Text for code:
~~~~~ ~~~~~~~~~~~~~~~~~~~~~
Code1 Standard paragraph text 1
Code2 Standard paragraph text 2
Code3 Standard paragraph text 3
Returns text "Standard paragraph text 2"
Reason for a central document is that text is changed on regular basis for
offers or legal updates.
I am sure (hope) that the answer is quite simple - but haven’t got much more
hair left to pull out! - Thanks