Doug,
I will look into using templates with an embedded macro to make the
formatting changes after the mail merge letter has been created.
Thanks for the Web site, that looks very interesting, I will need to
study it further and I will pass the URL on to my client.
As I mentioned in an earlier post, I am writing this database for a
client and they will only have a .mde file so they will not be able to
make any changes to any reports I supply. Doing this via Word has the
big advantage that they can design their letters exactly how they want
(and there could be dozens) whereas I would have to make any changes
they want to any reports.
I will see how I get on with the template idea and will come back with
more questions if I need to, thanks again for your help.
Peter Hibbs.
On Mon, 23 Feb 2009 20:46:32 +1000, "Doug Robbins - Word MVP on
news.microsoft.com" wrote:
The mail merge main document can certainly be saved as a template and if the
macro, to perform the task of replacing the text within a couple of
formatting marks with formatted text, is stored in that template, it would
be available for use on any document created from the template. It would
however be necessary for the mail merge main document to remain open for the
macros in that template to be available for use on the document created by
execution of the mail merge.
An alternative of course would be to use the mailmerge events that are
available and incorporate the code to do the formatting into some code that
would run as the mailmerge is executed. For an example of the use of those
events, see the add-in for creating individual letters from a mail merge
main document that you can down load from fellow MVP Graham Mayor's website
at:
http://www.gmayor.com/individual_merge_letters.htm
I have to admit however, I am wondering whether what you are wanting to do
is not easier to do with an Access report.