Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2005

Tip: Looking for answers? Try searching our database.

Word 2000 - Mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandra Jackson - 13 Jun 2005 19:10 GMT
We've been sent two Excel spreadsheets and we need to extract information
from both.  Is this possible?

To clarify: The names and addresses are held on one spreadsheet and we need
to extract information from the other to merge into a one-page document.
Cindy M  -WordMVP- - 14 Jun 2005 09:31 GMT
Hi Sandra,

> We've been sent two Excel spreadsheets and we need to extract information
> from both.  Is this possible?
>  
> To clarify: The names and addresses are held on one spreadsheet and we need
> to extract information from the other to merge into a one-page document.

Depends on what you need from that other document, and how it may be
displayed. It would also help to know the version of Office involved.

If the second document should display a table, based on a "User ID" from the
first, see the discussion on multiple records in the Mail Merge FAQ on my
website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Sandra Jackson - 14 Jun 2005 12:27 GMT
Thank you for responding.

Both Word and Excel are new to me and so I apologies if I’m not very clear
with my request.

I’m currently using Word 2000 and Excel 2000.

The two spreadsheets emailed to me were (Excel 2000):

The first spreadsheet holds all members’ names and addresses: ie:

Salutation  Initial Surname  Address1  Address 2, etc

The second spreadsheet holds members names and all account details relating
to that member, ie:

Salutation Initial  Surname  NI No  Account No  DoB Date joined company., etc

The data is to be merged into a letter.  Obviously the name and address is at
the top of the page and taken from the first spreadsheet.

The details from the second spreadsheet are to be included in a table format
on the second page of the letter.

I hope you can understand my request.
Cindy M  -WordMVP- - 15 Jun 2005 11:14 GMT
Hi Sandra,

> The details from the second spreadsheet are to be included in a table format
> on the second page of the letter.
>  
> I hope you can understand my request.

Yes, my advice remains the same. See the discussion in the Special Merges
sectino of my website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.