mail merge from database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erika - 19 Sep 2004 23:55 GMT

Hi. I'm trying to print envelopes from an Access database, using Mail
merge, and I really need some help. Haven't done a merge since forever.

I can't get it to merge and it's not drawing from the database. It's
showing in print preview, only one envelope, and it's picking up the
return address as the "To" address. I'm trying to go through the
database by clicking the arrows on the Merge toolbar and it only shows
this one address.

I hope that's clear.

Using Word 2000 and Access 97, Win-ME. Thanks!

Signature

Hugs, Erika

Reply to this Message

Doug Robbins - 20 Sep 2004 00:39 GMT

Hi Erika,

When you turn off the preview by clicking on the <<ABC>> button, what do you
see where the return address had appeared?

What you should see in that location is the relevant fields from your
database. If they do not appear in that location, you must insert them
there in the arrangement in which you wish them to appear.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi. I'm trying to print envelopes from an Access database, using Mail
> merge, and I really need some help. Haven't done a merge since forever.
[quoted text clipped - 8 lines]
>
> Using Word 2000 and Access 97, Win-ME. Thanks!

Reply to this Message

Erika - 20 Sep 2004 04:35 GMT

Hi, Doug. Yes, I do see the fields, and they are correct.

> Hi Erika,
>
[quoted text clipped - 17 lines]
>>>
>>> Using Word 2000 and Access 97, Win-ME. Thanks!

Signature

Hugs, Erika

Reply to this Message

Erika - 20 Sep 2004 04:41 GMT

PS: is Access to Word the most direct and easiest way to get my envelopes?

After many years I finally realized that I can quite easily print
mailing labels directly from Access, but in this case I would like to
print on the envelopes.

I can use Excel also, if that is any help.

Thanks!

Signature

Hugs, Erika

Reply to this Message

Erika - 20 Sep 2004 06:44 GMT

Hi. I've got the merge worked out - so never mind.

Now the printer won't work. I don't know what's wrong. Word will print a
regular sheet of paper but it won't print the merged envelope.

Signature

Hugs, Erika

Reply to this Message

sedur - 21 Sep 2004 09:40 GMT

> Hi. I'm trying to print envelopes from an Access database, using Mail
> merge, and I really need some help. Haven't done a merge since forever.
[quoted text clipped - 12 lines]
>
> Hugs, Erika

Reply to this Message