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.

insert Excel data into Word Mail Merge document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RRemy - 22 Jun 2005 14:38 GMT
I have a Word document set up for Mail Merge, and I'm trying to incorporate
data from Excel into the merged document.

I'm developing a Bid Manual, and I'm creating 45 individual bid specs.  Each
merged record needs to have its own unique (table/list/data--whatever way I
can get it into Word!)---this data is currently residing in 45 cell ranges (4
columns each, varying number of rows) in an Excel spreadsheet.

Oh, and I'm trying to make this process as automated as possible, since the
end users of this project will have minimum skills in Word or Excel.

I've tried all kinds of macros, links, etc. and I'm not getting
anywhere....anyone have any ideas???
Anne Troy - 22 Jun 2005 17:26 GMT
I may have JUST the thing, RRemy.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=381

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> I have a Word document set up for Mail Merge, and I'm trying to incorporate
> data from Excel into the merged document.
[quoted text clipped - 9 lines]
> I've tried all kinds of macros, links, etc. and I'm not getting
> anywhere....anyone have any ideas???
Cindy M  -WordMVP- - 25 Jun 2005 16:52 GMT
Hi =?Utf-8?B?UlJlbXk=?=,

Have you tried using a Database field to bring in the tables/lists from Excel
into a merge document? If not, see the article on my website for "one-to-many"
and the link to the sample file that describes how to do this.

> I have a Word document set up for Mail Merge, and I'm trying to incorporate
> data from Excel into the merged document.
[quoted text clipped - 9 lines]
> I've tried all kinds of macros, links, etc. and I'm not getting
> anywhere....anyone have any ideas???

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.