Mail Merge to files with filenames from database

[jbkd]

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

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>