If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tips for using Excel as data file in Word merge doct?
Is there a URL somewhere that explains this? My final merged document comes
out all wrong, so I know that I've made a mistake somewhere. But I like the ease of using Excel as the data source because of the cells (rows/columns) rather than setting up a table in Word. Thanks. |
#2
|
|||
|
|||
Tips for using Excel as data file in Word merge doct?
See
How to create a Mail merge http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm Creating a mail merge Data Source http://word.mvps.org/FAQs/MailMerge/...DataSource.htm It helps to have a heading row, as this provides names for the merge fields. It must be the first row in the range and there must not be any blank rows between the headings and the records. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "StargateFanFromWork" wrote in message ... Is there a URL somewhere that explains this? My final merged document comes out all wrong, so I know that I've made a mistake somewhere. But I like the ease of using Excel as the data source because of the cells (rows/columns) rather than setting up a table in Word. Thanks. |
#3
|
|||
|
|||
Tips for using Excel as data file in Word merge doct?
On Wed, 30 Jun 2004 00:34:41 -0500, "Suzanne S. Barnhill"
wrote: See How to create a Mail merge http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm Creating a mail merge Data Source http://word.mvps.org/FAQs/MailMerge/...DataSource.htm Hallelujah! Just read through the section on Excel as a data source and it looks good. It helps to have a heading row, as this provides names for the merge fields. It must be the first row in the range and there must not be any blank rows between the headings and the records. Yes, I had all of that so don't know why only 2 cells were picked as the source for all the fields!! I had labels full of "D."'s for the first names of 2 friends but in the first name, last name, address, city, province and postal code, all "D."'s! lol It was too funny. This should help. Thank you. |
#4
|
|||
|
|||
Tips for using Excel as data file in Word merge doct?
Do not know where best to post this question. New to this forum and format. By the way the response time is very, very slow on this server.
I want to merge Excel data from one column into a single Word Document. I am taking Visio flowcharts that have been linked to an Excel spreadsheet as a data source. I want to connect a Visio Shape number tag and text label and have it be the Section number in a Word document. By linking the Visio to the Word document I can have numbered processes explained in a procedures guide made in Word. I am almost there. I need to have the merge field in Word allow me to have one section merge wtih the first data in the column and then the second section get its data from the second row in the Excel data source column. How do I get the merge field to go to the next record and yet stay in the same document and not make a second document. I am very experienced in WordPerfect mailmerge. I have more than working knowledge of Word mail merge. But I am getting locked records if I just use the merge field alone repeated many times in the same Word document. Brent J Knipfer 940-594-9938 "StargateFan" wrote: On Wed, 30 Jun 2004 00:34:41 -0500, "Suzanne S. Barnhill" wrote: See How to create a Mail merge http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm Creating a mail merge Data Source http://word.mvps.org/FAQs/MailMerge/...DataSource.htm Hallelujah! Just read through the section on Excel as a data source and it looks good. It helps to have a heading row, as this provides names for the merge fields. It must be the first row in the range and there must not be any blank rows between the headings and the records. Yes, I had all of that so don't know why only 2 cells were picked as the source for all the fields!! I had labels full of "D."'s for the first names of 2 friends but in the first name, last name, address, city, province and postal code, all "D."'s! lol It was too funny. This should help. Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
changes to normal.dot | Dianah | New Users | 7 | June 17th, 2004 01:19 AM |
Linking data from Excel to Word | Kolja | General Discussion | 1 | June 9th, 2004 08:17 PM |
Sorting data according to the mm-yy in merged file | Kath | Mailmerge | 6 | June 5th, 2004 10:11 AM |
Merging Excel Data into Word Document | Debra Dalgleish | Worksheet Functions | 1 | February 16th, 2004 12:15 AM |
Excel merge files that work like Word merge files | Rick | Worksheet Functions | 2 | October 30th, 2003 01:30 AM |