Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print a data file from a mail merge doc?
Hello:
I would like to view all of my clients names and addresses in a list that I can then print. I have created a mail merge .doc or simply, labels for envelopes, that I then proceed to print on envelopes. I would like to see all of them in a list I can also print: Name Address City State Zip I cannot export it to Excel (that I am aware of). I cannot import it from Excel (ditto). I have multiple mail merge doc's and I do not want doubles. I also want to be able to find my entries when they come back in the mail informing me that the home owner has moved (nightmare). My friend said, "If a document is already merged, you will need to see the "data file" which you can access by opening up the merged doc in Word, go to Tools, and merge. There you will be able to locate the data file which will either be a table in Word or a table in Excel." I could not locate what he was typing about? Please help me. Shine on~ |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print a data file from a mail merge doc?
Create a directory/catalog merge containing all your fields in the cells of
a single row table and merge to a new document. See also http://www.gmayor.com/convert_labels...mail_merge.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Hello: I would like to view all of my clients names and addresses in a list that I can then print. I have created a mail merge .doc or simply, labels for envelopes, that I then proceed to print on envelopes. I would like to see all of them in a list I can also print: Name Address City State Zip I cannot export it to Excel (that I am aware of). I cannot import it from Excel (ditto). I have multiple mail merge doc's and I do not want doubles. I also want to be able to find my entries when they come back in the mail informing me that the home owner has moved (nightmare). My friend said, "If a document is already merged, you will need to see the "data file" which you can access by opening up the merged doc in Word, go to Tools, and merge. There you will be able to locate the data file which will either be a table in Word or a table in Excel." I could not locate what he was typing about? Please help me. Shine on~ |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print a data file from a mail merge doc?
Thank you, Graham.
But what I have done, just seconds before getting your reply is; I am opening the database file from My Data Sources in Access, then going to Forms, Create Forms by Using Wizard, Selecting all my fields, Naming the file Saving it to my desktop for later--later consisting of placing all the new data files on my external drive. Nightmare. Speaking of external drives (the reason I put the files on my desktop is coming up)... If my external drive E: is connected to the PC, I cannot run successfully (the reason I detached it) my printer. The reason I got the drive was to place all my music on there for my iPod which I later come to find is also E:. In addition to that--the external drive doesn't have all the music or sound cards I need to run iTunes so with 10,000 songs and over 80GB f music, I now have to SOMEHOW delete enough music (doubles etc) to fit ALL the MUSIC back on my PC (only 80GB) and fit it onto my 60GB iPod. You know, Graham. Nothing is ever easy. I will check out that link and try to save myself some time in the future. Currently, I think I can remember how to create the Access databases that will stay on my desktop until I can plug my external drive back up, after printing all my database lists. Nad once it's done... Yea! Very anti-climatic. Thank you, Graham. Smile on~ M "Graham Mayor" wrote: Create a directory/catalog merge containing all your fields in the cells of a single row table and merge to a new document. See also http://www.gmayor.com/convert_labels...mail_merge.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Hello: I would like to view all of my clients names and addresses in a list that I can then print. I have created a mail merge .doc or simply, labels for envelopes, that I then proceed to print on envelopes. I would like to see all of them in a list I can also print: Name Address City State Zip I cannot export it to Excel (that I am aware of). I cannot import it from Excel (ditto). I have multiple mail merge doc's and I do not want doubles. I also want to be able to find my entries when they come back in the mail informing me that the home owner has moved (nightmare). My friend said, "If a document is already merged, you will need to see the "data file" which you can access by opening up the merged doc in Word, go to Tools, and merge. There you will be able to locate the data file which will either be a table in Word or a table in Excel." I could not locate what he was typing about? Please help me. Shine on~ |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print a data file from a mail merge doc?
If your external hard drive does not work well with your printer then it is
probably trying to draw more power from the USB port than is available to it. Plug it into a port directly on your PC's mother board and avoid plugging it into a hub. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Thank you, Graham. But what I have done, just seconds before getting your reply is; I am opening the database file from My Data Sources in Access, then going to Forms, Create Forms by Using Wizard, Selecting all my fields, Naming the file Saving it to my desktop for later--later consisting of placing all the new data files on my external drive. Nightmare. Speaking of external drives (the reason I put the files on my desktop is coming up)... If my external drive E: is connected to the PC, I cannot run successfully (the reason I detached it) my printer. The reason I got the drive was to place all my music on there for my iPod which I later come to find is also E:. In addition to that--the external drive doesn't have all the music or sound cards I need to run iTunes so with 10,000 songs and over 80GB f music, I now have to SOMEHOW delete enough music (doubles etc) to fit ALL the MUSIC back on my PC (only 80GB) and fit it onto my 60GB iPod. You know, Graham. Nothing is ever easy. I will check out that link and try to save myself some time in the future. Currently, I think I can remember how to create the Access databases that will stay on my desktop until I can plug my external drive back up, after printing all my database lists. Nad once it's done... Yea! Very anti-climatic. Thank you, Graham. Smile on~ M "Graham Mayor" wrote: Create a directory/catalog merge containing all your fields in the cells of a single row table and merge to a new document. See also http://www.gmayor.com/convert_labels...mail_merge.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Hello: I would like to view all of my clients names and addresses in a list that I can then print. I have created a mail merge .doc or simply, labels for envelopes, that I then proceed to print on envelopes. I would like to see all of them in a list I can also print: Name Address City State Zip I cannot export it to Excel (that I am aware of). I cannot import it from Excel (ditto). I have multiple mail merge doc's and I do not want doubles. I also want to be able to find my entries when they come back in the mail informing me that the home owner has moved (nightmare). My friend said, "If a document is already merged, you will need to see the "data file" which you can access by opening up the merged doc in Word, go to Tools, and merge. There you will be able to locate the data file which will either be a table in Word or a table in Excel." I could not locate what he was typing about? Please help me. Shine on~ |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print a data file from a mail merge doc?
My PC has 4 USB jacks.
I have my remoteless mouse in one, the external hard drive in another and then the printer in another. When they're all connected and I try & print, It will only print like a 1/4 of the page. When I plug the iPod in the PC says it has found an unrecognizable USB device. I'm guessing the external drive & the iPod share the same drive E:. I don't know? It's inconvenient but not exactly broken. If I unplug the hard drive everything is a go. M "Graham Mayor" wrote: If your external hard drive does not work well with your printer then it is probably trying to draw more power from the USB port than is available to it. Plug it into a port directly on your PC's mother board and avoid plugging it into a hub. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Thank you, Graham. But what I have done, just seconds before getting your reply is; I am opening the database file from My Data Sources in Access, then going to Forms, Create Forms by Using Wizard, Selecting all my fields, Naming the file Saving it to my desktop for later--later consisting of placing all the new data files on my external drive. Nightmare. Speaking of external drives (the reason I put the files on my desktop is coming up)... If my external drive E: is connected to the PC, I cannot run successfully (the reason I detached it) my printer. The reason I got the drive was to place all my music on there for my iPod which I later come to find is also E:. In addition to that--the external drive doesn't have all the music or sound cards I need to run iTunes so with 10,000 songs and over 80GB f music, I now have to SOMEHOW delete enough music (doubles etc) to fit ALL the MUSIC back on my PC (only 80GB) and fit it onto my 60GB iPod. You know, Graham. Nothing is ever easy. I will check out that link and try to save myself some time in the future. Currently, I think I can remember how to create the Access databases that will stay on my desktop until I can plug my external drive back up, after printing all my database lists. Nad once it's done... Yea! Very anti-climatic. Thank you, Graham. Smile on~ M "Graham Mayor" wrote: Create a directory/catalog merge containing all your fields in the cells of a single row table and merge to a new document. See also http://www.gmayor.com/convert_labels...mail_merge.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Hello: I would like to view all of my clients names and addresses in a list that I can then print. I have created a mail merge .doc or simply, labels for envelopes, that I then proceed to print on envelopes. I would like to see all of them in a list I can also print: Name Address City State Zip I cannot export it to Excel (that I am aware of). I cannot import it from Excel (ditto). I have multiple mail merge doc's and I do not want doubles. I also want to be able to find my entries when they come back in the mail informing me that the home owner has moved (nightmare). My friend said, "If a document is already merged, you will need to see the "data file" which you can access by opening up the merged doc in Word, go to Tools, and merge. There you will be able to locate the data file which will either be a table in Word or a table in Excel." I could not locate what he was typing about? Please help me. Shine on~ |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print a data file from a mail merge doc?
As Graham pointed out, the Hard Drive is probably drawing too much power. I
would suggest that you get a powered USB hub and plug everything in to that, or at least the Hard Drive into that. The last one that I bought cost less than $10 -- 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 "MATTOUNET" wrote in message ... My PC has 4 USB jacks. I have my remoteless mouse in one, the external hard drive in another and then the printer in another. When they're all connected and I try & print, It will only print like a 1/4 of the page. When I plug the iPod in the PC says it has found an unrecognizable USB device. I'm guessing the external drive & the iPod share the same drive E:. I don't know? It's inconvenient but not exactly broken. If I unplug the hard drive everything is a go. M "Graham Mayor" wrote: If your external hard drive does not work well with your printer then it is probably trying to draw more power from the USB port than is available to it. Plug it into a port directly on your PC's mother board and avoid plugging it into a hub. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Thank you, Graham. But what I have done, just seconds before getting your reply is; I am opening the database file from My Data Sources in Access, then going to Forms, Create Forms by Using Wizard, Selecting all my fields, Naming the file Saving it to my desktop for later--later consisting of placing all the new data files on my external drive. Nightmare. Speaking of external drives (the reason I put the files on my desktop is coming up)... If my external drive E: is connected to the PC, I cannot run successfully (the reason I detached it) my printer. The reason I got the drive was to place all my music on there for my iPod which I later come to find is also E:. In addition to that--the external drive doesn't have all the music or sound cards I need to run iTunes so with 10,000 songs and over 80GB f music, I now have to SOMEHOW delete enough music (doubles etc) to fit ALL the MUSIC back on my PC (only 80GB) and fit it onto my 60GB iPod. You know, Graham. Nothing is ever easy. I will check out that link and try to save myself some time in the future. Currently, I think I can remember how to create the Access databases that will stay on my desktop until I can plug my external drive back up, after printing all my database lists. Nad once it's done... Yea! Very anti-climatic. Thank you, Graham. Smile on~ M "Graham Mayor" wrote: Create a directory/catalog merge containing all your fields in the cells of a single row table and merge to a new document. See also http://www.gmayor.com/convert_labels...mail_merge.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MATTOUNET wrote: Hello: I would like to view all of my clients names and addresses in a list that I can then print. I have created a mail merge .doc or simply, labels for envelopes, that I then proceed to print on envelopes. I would like to see all of them in a list I can also print: Name Address City State Zip I cannot export it to Excel (that I am aware of). I cannot import it from Excel (ditto). I have multiple mail merge doc's and I do not want doubles. I also want to be able to find my entries when they come back in the mail informing me that the home owner has moved (nightmare). My friend said, "If a document is already merged, you will need to see the "data file" which you can access by opening up the merged doc in Word, go to Tools, and merge. There you will be able to locate the data file which will either be a table in Word or a table in Excel." I could not locate what he was typing about? Please help me. Shine on~ |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detach or change SQL data source for Word template, and other Qs | Mailmerge | |||
How do I print off a data source in mail merge? | Microsoft Word Help | |||
Editing Mail Merge Recipients | Mailmerge | |||
word cannot open file as a data or header source bec it is a mail merge main doc | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge |