View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge to files with filenames from database

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!