B
bryan
I have created numerous templates all based upon 1 letterhead with the
company logo on top and address info in the footer.
I populate form fields from our host systems, select drop downs, check
boxes, etc upon doc new.
Recently our company started marketing new poducts within a new company. All
correspondece for this company uses a different header/footer, although
eveything else is the same (body of letter, form fields, etc).
Rather than creating templates for each company, I was thinking of having a
userform where the person could select which company. Based upon that info it
could load the appropriate header/footer.
I'll use Comp A and Comp B for example.
Thinking I could leave templates with Comp A header/footer.
Upon doc (new) a userform would ask which company.
If Comp A selected then no change.
If Comp B selected then would need to delete header/footer and insert new
header/footer.
By delteting and inserting header/footer, would that affect the body text,
form fields,etc?
Or is it easier to start with a blank doc and then show userform and then
insert the header/footer based upon choice?
Is this possible to do either of these and if so please offer suggestions on
how to go about this.
Or am I reaching and the best practice would be to use different templates
and just copy the letter body and macros?
Thanks,
Bryan
company logo on top and address info in the footer.
I populate form fields from our host systems, select drop downs, check
boxes, etc upon doc new.
Recently our company started marketing new poducts within a new company. All
correspondece for this company uses a different header/footer, although
eveything else is the same (body of letter, form fields, etc).
Rather than creating templates for each company, I was thinking of having a
userform where the person could select which company. Based upon that info it
could load the appropriate header/footer.
I'll use Comp A and Comp B for example.
Thinking I could leave templates with Comp A header/footer.
Upon doc (new) a userform would ask which company.
If Comp A selected then no change.
If Comp B selected then would need to delete header/footer and insert new
header/footer.
By delteting and inserting header/footer, would that affect the body text,
form fields,etc?
Or is it easier to start with a blank doc and then show userform and then
insert the header/footer based upon choice?
Is this possible to do either of these and if so please offer suggestions on
how to go about this.
Or am I reaching and the best practice would be to use different templates
and just copy the letter body and macros?
Thanks,
Bryan