How do I print a data file from a mail merge doc?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MATTOUNET - 16 Aug 2006 14:58 GMT

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 to this Message

Graham Mayor - 16 Aug 2006 15:11 GMT

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_into_mail_merge.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Hello:
> I would like to view all of my clients names and addresses in a list
[quoted text clipped - 22 lines]
>
> Shine on~

Reply to this Message

MATTOUNET - 16 Aug 2006 16:08 GMT

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>

> 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
[quoted text clipped - 26 lines]
> >
> > Shine on~

Reply to this Message

Graham Mayor - 17 Aug 2006 06:19 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Thank you, Graham.
> But what I have done, just seconds before getting your reply is;
[quoted text clipped - 69 lines]
>>>
>>> Shine on~

Reply to this Message

MATTOUNET - 21 Aug 2006 17:37 GMT

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>

> 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
[quoted text clipped - 74 lines]
> >>>
> >>> Shine on~

Reply to this Message

Doug Robbins - Word MVP - 21 Aug 2006 20:03 GMT

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

Signature

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

> My PC has 4 USB jacks.
> I have my remoteless mouse in one, the external hard drive in another and
[quoted text clipped - 90 lines]
>> >>>
>> >>> Shine on~

Reply to this Message

MATTOUNET - 22 Aug 2006 17:23 GMT

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

> 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,
[quoted text clipped - 95 lines]
> >> >>>
> >> >>> Shine on~

Reply to this Message

MATTOUNET - 30 Aug 2006 15:06 GMT

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

Will the Powered USB Hub "fix that" too?

Matthew

Reply to this Message

Graham Mayor - 30 Aug 2006 15:15 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Thank you, Doug.
> What if the External Drive is E:
[quoted text clipped - 122 lines]
>>>>>>>
>>>>>>> Shine on~

Reply to this Message

Peter Jamieson - 30 Aug 2006 15:27 GMT

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

> Thank you, Doug.
> What if the External Drive is E:
[quoted text clipped - 113 lines]
>> >> >>>
>> >> >>> Shine on~

Reply to this Message

MATTOUNET - 30 Aug 2006 17:42 GMT

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

> Windows should assign different drive letters when you plug the device in.
> You can sometimes also use the Device manager - e.g. try
[quoted text clipped - 127 lines]
> >> >> >>>
> >> >> >>> Shine on~

Reply to this Message

Rate this thread: