Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JEverhart JEverhart is offline
external usenet poster
 
Posts: 7
Default Merging from 3 data sources

I just posted this a while ago, received a reply, but can't get in to see it.
I have one Word doc, 3 data sources. How can I merge into that Word doc
using those 3 data sources? There is too much to combine all 3 sheets into
one.
--
JEverhart
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merging from 3 data sources

Well, I have posted this reply in both branches of the conversation.

OK, to /merge/ into a pre-existing table layout with a fixed cell layout
(column 1 with 20 cells, column 2 with 10 cells etc., unless I have
misunderstood?) is difficult because Word wants to fill the cells row by
row, i.e. row1col1, row1col2, row1col3, row2col1 etc. So you would really
have to rearrange your data in that sequence.

In this case it might be easier not to use a merge, but to copy/paste
special|paste link each cell into your table. In fact, if you select the
first cell you want to use in Excel, then edit copy, then edit|paste, paste
link (use a plain text or rtf format) into word, then use Alt-F9 to reveal
the pasted LINK field code in Word. You should be able to copy the LINK
field and modify the workbook/sheet/cell reference for each cell in your
table.

(You'd need Excel on the machine that's going to do the "merge" to do it
that way).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"JEverhart" wrote in message
...
I just posted this a while ago, received a reply, but can't get in to see
it.
I have one Word doc, 3 data sources. How can I merge into that Word doc
using those 3 data sources? There is too much to combine all 3 sheets
into
one.
--
JEverhart


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
Merging Word doc with 3 data sources JEverhart Mailmerge 8 August 21st 08 10:29 PM
Merging from two sources (Word and Access) and updating both Shimon Mailmerge 1 May 27th 08 11:00 PM
Merging from two sources Richard Mailmerge 2 September 14th 07 08:48 PM
merging 2 data sources pumpkin4455 Mailmerge 2 April 27th 06 04:17 PM
multiple data sources and data form Chico Mailmerge 1 October 5th 05 04:56 AM


All times are GMT +1. The time now is 06:02 AM.

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

About Us

"It's about Microsoft Word"