View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge to files with filenames from database

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!