Mail Merges in Access/Word 2003

[darnnews]

I have set up a mail merge to create blocks that will look like this:

New York Times, 6/22/1989.
Circulation: 1,200,000
"Headline," by Author.
Description.
URL.
Two problems I am having:

1) It seems I am limited to using an SQL query that is no more than 255
chars. Any way around this?

2) How do I get the blocks to appear one after another, instead of one
per page?
Thanks,
Andrew

[MGFoster]

darnnews wrote:

I have set up a mail merge to create blocks that will look like this:

New York Times, 6/22/1989.
Circulation: 1,200,000
"Headline," by Author.
Description.
URL.
Two problems I am having:

1) It seems I am limited to using an SQL query that is no more than 255
chars. Any way around this?

2) How do I get the blocks to appear one after another, instead of one
per page?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

1) AFAIK, there is no limit to an Access query's SQL length. If there
is a limit, it is 255 chars.

2) Instead of doing a mail merge (I'm assuming you mean w/ MS Word),
use a Report label wizard to get the blocks to align on a page as you
want.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRKmRXYechKqOuFEgEQLAiACdHjTXz7FFMv7zVu4B2t2pFK ViNzwAoNRT
C4zvtpWVylDjXYMGiqaHLZjB
=9wjF
-----END PGP SIGNATURE-----