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 / October 2003

Tip: Looking for answers? Try searching our database.

Mail Merge from Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ernesto De Leon - 03 Oct 2003 21:39 GMT
I am trying to merge address information along with some
money amounts into a Standard Word 2000 form from Excel
2000.  I go into the mail merge option and select to
create the main document and then select the data source
which is open data select the excel sheet with the info on
it and then click on merge.  When I do that the info from
the spreadsheet does have the proper alignment.  It all
gets crammed on top of eachother on the righthand side of
the sheet.  I'm lost and have no idea where to start
looking for a solution to this.  Please help!!!
Thanks,
Ernie
Peter Jamieson - 04 Oct 2003 09:04 GMT
I can't work out exactly what you are doing, but suspect you are missing
some steps as you don't mention them.

After you have selected your data source, there is still nothing in the
docuemtn that tells Word what to print or how to lay out the output. You
need to create the layout you want, and insert { MERGEFIELD } fields for
each item in the data source that you want displayed. These { MERGEFIELD }
fields are "placeholders" that tell Word where to put the data from each
record in the data source. You can insert them using the "More Items..."
option in Step 4 of the merge wizard, and they may look like <<fieldname>>
or { MERGEFIELD fieldname }, or display data the Excel sheet if you are
previewing. Because Insert Merge Field dialog box is modal and you cannot
type anything in the document while you are inserting them, you may well
find that everything is bunched up - after you have closed the dialog you
would need to edit the document and put some tabs between the merge fields,
or create whatever layout you need.
--
Peter Jamieson
MS Word MVP

> I am trying to merge address information along with some
> money amounts into a Standard Word 2000 form from Excel
[quoted text clipped - 8 lines]
> Thanks,
> Ernie
 
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.