access merge to word

[Guest]

Trying to merge access file into word as a directory. I've had to add names
to end of access and then sort alphabetically. That works. But when I
complete the merge, the added name prints at the end of the document instead
of where it belongs alphabetically. I also want blank lines where I have
blank fields. HELP!

Patricia

 

[Guest]

Patricia:

If you use a sorted query as the data source for the merge rather than the
base table you should be able to order the list in Word. You'll find a demo
of mine of various Access to Word operations using automation at:

http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=23781&webtag=ws-msdevapps

Blank lines are retained or suppressed by setting the SuppressBlankLines
property of the MailMerge object of the Document object in Word. The
functions in my demo include an argument to allow either (defaulting to True).

Ken Sheridan
Stafford, England

 

[Joseph Meehan]

Trying to merge access file into word as a directory. I've had to
add names to end of access and then sort alphabetically. That works.
But when I complete the merge, the added name prints at the end of
the document instead of where it belongs alphabetically. I also want
blank lines where I have blank fields. HELP!

Patricia

It is best to consider tables as only buckets of data and not an ordered
list.

You can make a query and establish a sort order there and it will stay
and it can be your source for the merge.

 

[Guest]

Ken,

Please contact me by private e-mail. I attempted to send a message to you,
using the e-mail address that is shown in the Readme.txt file associated with
your download.

My e-mail address is available at the bottom of the contributor's page
indicated below.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________