Mail Merge to files with filenames from database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jbkd@cox.net - 03 Aug 2006 01:35 GMT

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!

Reply to this Message

Doug Robbins - Word MVP - 03 Aug 2006 04:36 GMT

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.

Signature

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

> Hi, and thank you for this wonderful group.
>
[quoted text clipped - 9 lines]
>
> Thanks!

Reply to this Message

Graham Mayor - 03 Aug 2006 09:37 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> See the "Individual Merge Letters" item on fellow MVP Graham Mayor's
> website at:
[quoted text clipped - 22 lines]
>>
>> Thanks!

Reply to this Message

Rate this thread: