moving data from excel spreadsheet to word document

[Guest]

I have a spreadsheet and basically what I want to do is move the information
in it to certain areas in a microsoft word document. Should I try to do this
from the word document or from the excel spreadsheet? I hope this is the
right newsgroup sorry if it isn't.
thanks in advance

 

[Debra Dalgleish]

It depends on what data you're trying to move. If you have rows of data
in Excel, and want to create customized documents in Word, you could use
Word's mail merge feature.

There's mail merge information on the Word MVP site:

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

And David McRitchie has instructions on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

 

[Guest]

Thanks this does help it gives me a place to start. I also didn't know that
you could have conditions on the mail merge as well because I do have some
where if the value is empty don't print it and such. Can I create a mail
merge in a macro?? Getting a little ahead of myself I think. Anyways thanks
those sights really helped.
Heather

 

[Debra Dalgleish]

You're welcome. See what the mail merge can do, without macros, first.
Then, if you decide to automate, you could ask for help in one of the
Word newsgroups, if that's where the macro will be.