Mail Merge from Excel

[Ernesto De Leon]

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]

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.