data into template

[Curt]

Have a word file in properties has no ext. called temp it was created by
merge from excel. I created a template "I think" that I want to insert this
data into. When I try to merge the insert merge field has all fields
together. This is a first for me into this area. The template I tried to
layout the way I want print out to be. Do I need to change the temp file
someway. It does ask for delimiter selection when trying merge. I need to
eliminate this selection if possible. Anyone willing I am stuck.
Thanks

 

[Doug Robbins - Word MVP]

You should use the Excel file (or a modified version of it) as the data
source.

See the article "Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Curt]

Made a text file from excel data. Was only way I know to condense data. When
I try to merge to a word doc for printing. It stops on the delimiter screen
for selection. This why I went this other way. Did the selection when I
recorded the macro for printing. Is there a better way to obtain the needed
data? I am trying to automate this as it will be used at staging for the
parade.
Also when trying to get to this page from link in e-mail it wont go thru.
Have to work around.

 

[Doug Robbins - Word MVP]

What do you mean by "condense data"?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Curt]

Trying to do a merge from the excel sheet took to long for word to search the
full sheet. The text file created a data sheet with no blank rows to look at.
I guess I should of said it got rid of blank rows on excel sheel. Hope I
explained myself better.

 

[Doug Robbins - Word MVP]

How about sorting the data on the excel sheet in descending order to get the
blank rows at the bottom of the sheet.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Curt]

The data in the excel sheet is all together. No blanks. What I elimanted was
the rows after the data. When I merged off the excel sheet with blank rows
after data was what took so long. Maybe I am missing something.
Thanks

 

[Curt]

thru discussion I finnally found an answer
Thanks