Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ang Ang is offline
external usenet poster
 
Posts: 9
Default how do i import an excel sheet into a word merge document

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 ??
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default how do i import an excel sheet into a word merge document

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/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

or at:

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


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

"Ang" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't display excel sheet within Word (EMBED Excel.Sheet.8) HR Duvall Microsoft Word Help 3 May 14th 23 02:49 AM
Using Mail Merge to import Excel data to Word for printing checks [email protected] Mailmerge 2 November 3rd 06 06:10 AM
How do i mail merge in word from an excel sheet? Connie Mailmerge 1 June 16th 06 04:32 AM
includetext field in word to import excel work sheet MandyK Mailmerge 2 September 8th 05 12:40 PM
Import Excel sheet John Taylor Page Layout 3 March 7th 05 10:04 AM


All times are GMT +1. The time now is 09:58 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"