Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do i print out just my database table (e.g.names & addresses)?
Hi
I have created and merged my database (showing address details) with my letters, but wish to have a printed out list just with the database information (for ease of checking). I don't wish to print out 100 letters just to have this information. Or do i have to create another document made up of labels/cells / table for it to do this? Cheers Sue |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do i print out just my database table (e.g.names & addresses)?
Use a Catalog (or in Word XP and later it is called Directory) type
mailmerge in the main document of which you set up a one row table with as many columns as you need for the fields that you want to display. Attach this main document to the data source that you used for the letters and insert the mergefields into the cells of the table, one to a a cell. Then, when you execute this merge to a new document, you will get a table containing a row of data for each record in the data source. -- 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 "Reiki Sue" Reiki wrote in message ... Hi I have created and merged my database (showing address details) with my letters, but wish to have a printed out list just with the database information (for ease of checking). I don't wish to print out 100 letters just to have this information. Or do i have to create another document made up of labels/cells / table for it to do this? Cheers Sue |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do i print out just my database table (e.g.names & address
Hi Doug
Many thanks for this advice. I will give it ago. I used to like the old way of doing mailmerge e.g. from an excel spreadsheet and merged with other document. I don't like the way that M/Soft have done this version as i don't feel i have complete quick control over it. But never mind... If you don't hear from me again please assume it has worked. Many thanks again Kind Regards Sue "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge in the main document of which you set up a one row table with as many columns as you need for the fields that you want to display. Attach this main document to the data source that you used for the letters and insert the mergefields into the cells of the table, one to a a cell. Then, when you execute this merge to a new document, you will get a table containing a row of data for each record in the data source. -- 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 "Reiki Sue" Reiki wrote in message ... Hi I have created and merged my database (showing address details) with my letters, but wish to have a printed out list just with the database information (for ease of checking). I don't wish to print out 100 letters just to have this information. Or do i have to create another document made up of labels/cells / table for it to do this? Cheers Sue |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do i print out just my database table (e.g.names & address
There is nothing stopping you from using an Excel spreadsheet as a data
source. -- 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 "Reiki Sue" wrote in message ... Hi Doug Many thanks for this advice. I will give it ago. I used to like the old way of doing mailmerge e.g. from an excel spreadsheet and merged with other document. I don't like the way that M/Soft have done this version as i don't feel i have complete quick control over it. But never mind... If you don't hear from me again please assume it has worked. Many thanks again Kind Regards Sue "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge in the main document of which you set up a one row table with as many columns as you need for the fields that you want to display. Attach this main document to the data source that you used for the letters and insert the mergefields into the cells of the table, one to a a cell. Then, when you execute this merge to a new document, you will get a table containing a row of data for each record in the data source. -- 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 "Reiki Sue" Reiki wrote in message ... Hi I have created and merged my database (showing address details) with my letters, but wish to have a printed out list just with the database information (for ease of checking). I don't wish to print out 100 letters just to have this information. Or do i have to create another document made up of labels/cells / table for it to do this? Cheers Sue |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do i print out just my database table (e.g.names & address
Hi Doug,
Well i followed your advice and tweaked it abit. Then did one row split into the number of data field entries. Entered in the datafields. Then entered 'next row' above it and copied this for my 25 letters and connected them to my data source. However most strange but it won't under any circumstances include the first letters details. I have deleted and readded and deleted the 'next row' wording, in case that is causing it to go straight onto the second letters details. In the end i had to manually insert the first letters details. Any idea what i need to do to stop this occuring? I shall also have a go with doing an excel version. Thanks for that tip. Kind Regards Sue "Doug Robbins - Word MVP" wrote: There is nothing stopping you from using an Excel spreadsheet as a data source. -- 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 "Reiki Sue" wrote in message ... Hi Doug Many thanks for this advice. I will give it ago. I used to like the old way of doing mailmerge e.g. from an excel spreadsheet and merged with other document. I don't like the way that M/Soft have done this version as i don't feel i have complete quick control over it. But never mind... If you don't hear from me again please assume it has worked. Many thanks again Kind Regards Sue "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge in the main document of which you set up a one row table with as many columns as you need for the fields that you want to display. Attach this main document to the data source that you used for the letters and insert the mergefields into the cells of the table, one to a a cell. Then, when you execute this merge to a new document, you will get a table containing a row of data for each record in the data source. -- 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 "Reiki Sue" Reiki wrote in message ... Hi I have created and merged my database (showing address details) with my letters, but wish to have a printed out list just with the database information (for ease of checking). I don't wish to print out 100 letters just to have this information. Or do i have to create another document made up of labels/cells / table for it to do this? Cheers Sue |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do i print out just my database table (e.g.names & address
Do not use the 'next row' above it. Put in the mailmerge document JUST what
I said and NOTHING more. -- 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 "Reiki Sue" wrote in message ... Hi Doug, Well i followed your advice and tweaked it abit. Then did one row split into the number of data field entries. Entered in the datafields. Then entered 'next row' above it and copied this for my 25 letters and connected them to my data source. However most strange but it won't under any circumstances include the first letters details. I have deleted and readded and deleted the 'next row' wording, in case that is causing it to go straight onto the second letters details. In the end i had to manually insert the first letters details. Any idea what i need to do to stop this occuring? I shall also have a go with doing an excel version. Thanks for that tip. Kind Regards Sue "Doug Robbins - Word MVP" wrote: There is nothing stopping you from using an Excel spreadsheet as a data source. -- 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 "Reiki Sue" wrote in message ... Hi Doug Many thanks for this advice. I will give it ago. I used to like the old way of doing mailmerge e.g. from an excel spreadsheet and merged with other document. I don't like the way that M/Soft have done this version as i don't feel i have complete quick control over it. But never mind... If you don't hear from me again please assume it has worked. Many thanks again Kind Regards Sue "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge in the main document of which you set up a one row table with as many columns as you need for the fields that you want to display. Attach this main document to the data source that you used for the letters and insert the mergefields into the cells of the table, one to a a cell. Then, when you execute this merge to a new document, you will get a table containing a row of data for each record in the data source. -- 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 "Reiki Sue" Reiki wrote in message ... Hi I have created and merged my database (showing address details) with my letters, but wish to have a printed out list just with the database information (for ease of checking). I don't wish to print out 100 letters just to have this information. Or do i have to create another document made up of labels/cells / table for it to do this? Cheers Sue |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print names and addresses on a preprinted postcard? | Mailmerge | |||
How can I create labels from names and addresses in Excel? | Microsoft Word Help | |||
How do I add multiple names and addresses to a transmittal? | Mailmerge | |||
how do I extract addresses in word documents and create a database | Mailmerge | |||
How do I center my names and addresses in labels? | Mailmerge |