[[email protected]]

Hi, and thank you for this wonderful group.

Question 1: I want to create a mail merge where each letter is saved as
a separate file with the recipient as the file name. Example: the
merged letter to Joe Smith would be joesmith.doc. The name for each
file could either come from a field in the database, or it could be the
top line of the merged letter (in white so no one sees it). Is this
possible?

Question 2: If #1 is possible, is it also possible to save these files
as .htm files?

Thanks!

[Doug Robbins - Word MVP]

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.

It should be possible to modify the code in the add-in so that the files are
saved in html format.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

wrote in message
oups.com...
Hi, and thank you for this wonderful group.

Question 1: I want to create a mail merge where each letter is saved as
a separate file with the recipient as the file name. Example: the
merged letter to Joe Smith would be joesmith.doc. The name for each
file could either come from a field in the database, or it could be the
top line of the merged letter (in white so no one sees it). Is this
possible?

Question 2: If #1 is possible, is it also possible to save these files
as .htm files?

Thanks!

[Graham Mayor]

Or if you find Doug's add-in too difficult to edit - the Splitter macro on
that same page needs only two minor edits to achieve the same result.

Change the line:
DocName = "D:\My Documents\Temp\Workgroup\" & Format(Date, mask) _
& " " & LTrim$(Str$(Counter)) & ".doc"
to
DocName = "D:\My Documents\Temp\Workgroup\" & Format(Date, mask) _
& " " & LTrim$(Str$(Counter)) & ".htm"

and the line
ActiveDocument.SaveAs FileName:=DocName, FileFormat:=wdFormatDocument
to
ActiveDocument.SaveAs FileName:=DocName, FileFormat:=wdFormatHTML



--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Doug Robbins - Word MVP wrote:
See the "Individual Merge Letters" item on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to
Separate Files" that I have written and that can be downloaded from
that site will allow you to create each letter as a separate file
with a filename taken from a field in the data source with a minimum
of fuss.
It should be possible to modify the code in the add-in so that the
files are saved in html format.



wrote in message
oups.com...
Hi, and thank you for this wonderful group.

Question 1: I want to create a mail merge where each letter is saved
as a separate file with the recipient as the file name. Example: the
merged letter to Joe Smith would be joesmith.doc. The name for each
file could either come from a field in the database, or it could be
the top line of the merged letter (in white so no one sees it). Is
this possible?

Question 2: If #1 is possible, is it also possible to save these
files as .htm files?

Thanks!