Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lookup Values in MailMerge

Status
Not open for further replies.
gmusgrave

gmusgrave

IS-IT--Management
Joined
Apr 8, 2002
Messages
3
Location
GB
I'm using a simple customer/order/order detail set of tables to record orders and need to print invoices. Using mailmerge to existing Word docs seems the easiest route. I'm using a query to select all of the required fields from the tables and running the merge off this. As expected, once in Word, the lookup type fields only display the lookup field not the description (eg: TitleID rather than TitleDesc from my tblTitle table, so I get "1 John Doe" rather than "Mr John Doe").

I'm sure this can be achieved. Any ideas?

TIA
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
936
PrimoSteve
PrimoSteve
Xavierparkash
  • Locked
  • Question Question
MS Access Slow Search in Linked Database
Replies
0
Views
629
Xavierparkash
Xavierparkash
caykamanj1966
  • Locked
  • Question Question
Duplicate Records in DataSheet View
Replies
5
Views
999
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
4K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top