Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Gordon Biggar Gordon Biggar is offline
external usenet poster
 
Posts: 36
Default Transfering Excel data into Word data file

Since I have been unable to solve the DDE problem (refer to Sept. 30 post
below), concerning the use of Excel name and address data files being used
by Word merge files, I have created a name and address file (Header and
Data) in Word instead. For some reason, this works, whereas attempts to use
an Excel data file does not.

However, two things arise. The Header file that I use is long enough that I
cannot view all of the fields on the monitor, and there is no ability to
scroll across the page.

Secondly, I do keep numeric information in some of the fields in the Data
file, which is why I originally used an Excel-based data file. Formerly, to
update any data in the Excel data file, I would simply copy the incoming
data from selected columns in incoming Excel spreadsheets, and copy the data
into the appropriate fields in the name and address spreadsheet. Is there a
way that I can take incoming data from Excel spreadsheets and copy it into
the Word name and address file (i.e, the new data file)? Or, will I have to
type it in manually, a laborious process?

Thanks in advance.

Gordon Biggar
Houston, Texas


 
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
Link Excel data to Word Form with automatic fill of other data DavidMSI Microsoft Word Help 1 January 19th 07 10:52 AM
How do I attach data from an Excel file to a Word document? mia New Users 1 October 10th 06 11:43 PM
Need HELP transfering data from word to excel sheet ACcesstini Microsoft Word Help 4 June 2nd 06 05:42 AM
How to re-connect merged data (excel file) in the word file jose Mailmerge 1 May 11th 06 02:45 PM
Word Mailmerge using Excel Data File a_ryan1972 Mailmerge 1 April 3rd 06 09:21 AM


All times are GMT +1. The time now is 06:59 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"