Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MATTOUNET MATTOUNET is offline
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MATTOUNET MATTOUNET is offline
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MATTOUNET MATTOUNET is offline
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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~






  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MATTOUNET MATTOUNET is offline
external usenet poster
 
Posts: 6
Default How do I print a data file from a mail merge doc?

Thank you, Doug.
So then what I will do is buy the USB Plug and plug all of my PC accessories
into it?
Printer
iPod
External Drive
Mouse
Thank you, Doug.
Smile on~

Matthew

"Doug Robbins - Word MVP" wrote:

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~






  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MATTOUNET MATTOUNET is offline
external usenet poster
 
Posts: 6
Default How do I print a data file from a mail merge doc?

Thank you, Doug.
What if the External Drive is E:
and the iPod is E:?

Will the Powered USB Hub "fix that" too?

Matthew

"Doug Robbins - Word MVP" wrote:

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~






  #9   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How do I print a data file from a mail merge doc?

You can change the drive letter of one or the other using the disc
management module of the Computer Management tools (Control Panel). Though
in practice Windows should re-assign conflicting drive letters if both are
present.

The powered hub should fix the inadequate power delivery from the USB port
to the external drive.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



MATTOUNET wrote:
Thank you, Doug.
What if the External Drive is E:
and the iPod is E:?

Will the Powered USB Hub "fix that" too?

Matthew

"Doug Robbins - Word MVP" wrote:

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~



  #10   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How do I print a data file from a mail merge doc?

Windows should assign different drive letters when you plug the device in.
You can sometimes also use the Device manager - e.g. try

Start|right-click on My Computer|Manage, then look for Computer Management
(local)|Storage|Disk Management (and/or System Tools|Device manager) then
have a look at the relevant volumes. I leave you to explore those areas
(since this group is really about Word mailmerge and not Windows and
hardware issues), selecting the relevant volumes, right-clicking and
choosing change drive letters and paths may be where you need to be.

Depends on the version of Windows though.

Peter Jamieson

"MATTOUNET" wrote in message
...
Thank you, Doug.
What if the External Drive is E:
and the iPod is E:?

Will the Powered USB Hub "fix that" too?

Matthew

"Doug Robbins - Word MVP" wrote:

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~










  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MATTOUNET MATTOUNET is offline
external usenet poster
 
Posts: 6
Default How do I print a data file from a mail merge doc?

Hi, Peter.
Thank you for your response.
I can't believe I've figured this out.
Now I changed my drive to M:.
I have not rebooted.
I am loading all my songs into iTunes (9,345) and hopefully when I plug in
the iPod (which is E, this should all be behind me.
And if it doesn't, you'll be hearing from me, smirk.
Thank you for your time, Peter.
Shine oN~


Matthew

"Peter Jamieson" wrote:

Windows should assign different drive letters when you plug the device in.
You can sometimes also use the Device manager - e.g. try

Start|right-click on My Computer|Manage, then look for Computer Management
(local)|Storage|Disk Management (and/or System Tools|Device manager) then
have a look at the relevant volumes. I leave you to explore those areas
(since this group is really about Word mailmerge and not Windows and
hardware issues), selecting the relevant volumes, right-clicking and
choosing change drive letters and paths may be where you need to be.

Depends on the version of Windows though.

Peter Jamieson

"MATTOUNET" wrote in message
...
Thank you, Doug.
What if the External Drive is E:
and the iPod is E:?

Will the Powered USB Hub "fix that" too?

Matthew

"Doug Robbins - Word MVP" wrote:

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Detach or change SQL data source for Word template, and other Qs SJMac Mailmerge 6 July 27th 06 10:12 AM
How do I print off a data source in mail merge? R Hoff Microsoft Word Help 1 June 21st 06 04:13 PM
Editing Mail Merge Recipients Stan W. Mailmerge 8 May 4th 06 05:03 AM
word cannot open file as a data or header source bec it is a mail merge main doc gerry Mailmerge 1 November 20th 05 02:24 PM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 06:10 AM


All times are GMT +1. The time now is 07:06 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"