Merging Excel fields to a Word form

[rookd]

Hey everyone. I'm sure there's an easy solution to this, but I've tried searching the net and both Word's and Excel's help documents trying to find an answer, but I'm probably just not searching for the right terminology.

Basically what it comes down to is this:

I have a word document that contains an empty form. The contents of these forms are already contained and filled in on an Excel spreadsheet, but for some reason Corperate wants it all done in Word now (gotta love corperate). So I was wondering if there was some way to automatically merge the documents. I tried writing a macro, but I'm not really the best at that yet.

Any help, or at least a point in the right direction would be helpful and appreciated.

 

[Von Pookie]

Look into using mail merge in Word.

 

[rookd]

I wasn't aware that the mail merger would work like that, but I will definitely give it a try. Thank you.

 

[rookd]

That worked perfectly. Thank you so much

 

[Von Pookie]

Well, assuming I'm understanding you correctly...

Either way, it can't hurt knowing about mail merge

 

[rookd]

Yeah, well, I only knew mail mergers minimally...from about 5 years ago when I had to print a bunch of letter labels, and then promptly forgot about it as I started teaching myself programing and networks. Didn't realize it was so much more powerful. Thanks again. I really appreciate it.

 

[rookd]

Oh, another quick question. Is there any way that I can get the mail merger to merge the data into multiple documents? Right now each row in the xls basically fills out a form. currently it's dumping all of the merge data into a single, many paged document with a form on each page.

Could I somehow change that into saving it into multiple documents rather than multiple pages?

 

[Von Pookie]

Hmm....I'm not sure. It's been years since I've actually had to do a mail merge, and even then that PC was using Office 97. Let's see...

Using Word XP at least, all I can really see is doing the "merge to new document" one by one for each record. If you do "all" or "from x to x", it will put all of those letters/records in one multi-page file.

That's all I can seem to find at the moment, at any rate.

 

[rookd]

Yeah, that's all I could find as well, and it's probably all there is. Thanks again for all of your help. It's really appreciated.

 

[Anne Troy]

You've got a few options.

If you want to make ONE document at a time, you might want this instead of mail merge:
http://vbaexpress.com/kb/getarticle.php?kb_id=381

But if you're going to use mail merge, you then might want this:
http://vbaexpress.com/kb/getarticle.php?kb_id=139