1) I have a query with mail merge fields (QryWordMerge) and a memo field in a Table holding copies of Word templates to be mail merged.
The templates in the memo fields look like
2) I have textbox (DocContent) on a form (frmDocuments) which displays a pre-merge preview and was wondering what the best way would be to replace the merge fields e.g. «PersonFullName» in the textbox (not the final mail merge) with coresponding fields from QryWordMerge, so that «PersonFullName» will display as say Mr. Peter Smith.
(I don't want to save the changes so perhaps I'll use an unbound textbox to show the preview populated with a dlookup)
Any ideas would be much appreciated.
The templates in the memo fields look like
«DateTodayLong»
«PersonFullName»
«PersonAddressBlock»
«PesronTitleAndLastName»,
RE: «RefNo»
blah blah blah «DateReceivedLong» blah blah blah
Yours sincerely
«CWLetterName»
«CWJobTitle»
2) I have textbox (DocContent) on a form (frmDocuments) which displays a pre-merge preview and was wondering what the best way would be to replace the merge fields e.g. «PersonFullName» in the textbox (not the final mail merge) with coresponding fields from QryWordMerge, so that «PersonFullName» will display as say Mr. Peter Smith.
(I don't want to save the changes so perhaps I'll use an unbound textbox to show the preview populated with a dlookup)
Any ideas would be much appreciated.