Getting data from Excel into Word

[Jere]

Hi

I'm just starting to learn VBA, and I have read lots of the tutorials that you all seem to recomend here, but I still haven't figured out how I can do this: I have a one page personel file that needs to get it's data from an exel sheet that has it. The sheet has a random amount of names (and their data) and I need to create a seperate personel file for each of the names and their data into the same word document. Is this possible in any way

Cheers.

 

[Doug Robbins - Word MVP]

Sounds like an application for mailmerge.

See the article “How to create a Mail Merge†at:

http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm


--
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

Hi!

I'm just starting to learn VBA, and I have read lots of the tutorials that

you all seem to recomend here, but I still haven't figured out how I can do
this: I have a one page personel file that needs to get it's data from an
exel sheet that has it. The sheet has a random amount of names (and their
data) and I need to create a seperate personel file for each of the names
and their data into the same word document. Is this possible in any way?

 

[Jere]

Thanks

I'll look into that.

 

[Jere]

Thanks Doug

It worked like a charm, and was just what I was looking for. Now I can do huge piles of forms no time. I much appreciate your help!

Thanks once more
- Jere