Import Excel to Word Form, Save as Individual Files

  • Thread starter Thread starter D
  • Start date Start date
D

D

Hey guys-
New to this forum, seems like a TON of great info here. I'm gonna post this
to a couple different newsgroups, so I apologize in advance. I just don't
know the proper place for it...

I have a psuedo database in Excel, and a Word form (all 2002/XP). I need to
export from Excel to the Word form- each row in Excel represents a new
individual form (the cells and fields are already linked up). Then, each
form (or row in Excel) will of coarse be saved as a separate word doc. How
do I go about doing this? Obviously, I'd like it to be some sort of Macro to
where the saving is quick and easy.
Thanks!
D
 
This sounds like a simple application of a form letter mail merge using
Excel as a data source. The basics (albeit based on labels here) are covered
in http://www.gmayor.com/mail_merge_labels_with_word_xp.htm.

Merging to a new document will put all your letters in a single file. You
then need to use a macro to split to separate files. Fellow MVP Doug Robbins
came up with the code to do this - see
http://www.gmayor.com/individual_merge_letters.htm

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Answered in Mailmerge.Fields ng

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
Back
Top