Mail merging (1 Viewer)

LHood

New member
Local time
Today, 05:31
Joined
Nov 10, 2021
Messages
2
Hi,

So i have an access database that is in a mail sorted order so has to stay in this order and i have a word document with two different letters (letter a and Letter b), the records on the database are coded up to say which letter they need. Is there a way to mail merge them in the correct mail sort order to the correct letter in word?

Many thanks for any help!
Laura
 

Ranman256

Well-known member
Local time
Today, 00:31
Joined
Apr 9, 2015
Messages
4,123
make a query of how you want it sorted, then in Word, run thru the Merge Wizard and choose that query as source.
 

mike60smart

Registered User.
Local time
Today, 05:31
Joined
Aug 6, 2017
Messages
1,237
Hi Laura
Why not just generate the Letters in Access?
 

Gasman

Enthusiastic Amateur
Local time
Today, 05:31
Joined
Sep 21, 2011
Messages
10,868
Just select the a records, then the b records?
 

Users who are viewing this thread

Top Bottom