how do i import an excel sheet into a word merge document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ang - 12 Nov 2007 11:25 GMT

I have an excel spreadsheet with for eg. column a1 is client name, b1
address, c1 telephone number. Then in column a2 i have the same clients
name, b2 same address, but in c2 i have a different telephone number. What i
need to know is how do i merge this info into a word document using only
information in A1 but ALL the information in column C, from line 1 - 2 ??

Reply to this Message

Doug Robbins - Word MVP - 12 Nov 2007 19:22 GMT

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

Signature

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

>I have an excel spreadsheet with for eg. column a1 is client name, b1
> address, c1 telephone number. Then in column a2 i have the same clients
> name, b2 same address, but in c2 i have a different telephone number.
> What i
> need to know is how do i merge this info into a word document using only
> information in A1 but ALL the information in column C, from line 1 - 2 ??

Reply to this Message