Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Big Bad Bev Big Bad Bev is offline
external usenet poster
 
Posts: 2
Default database field - merge single field from excel list

have 2 data sources, a progress db & a 2 column list in excel, column
A containing the same data as the word merge field, and column B is
the data I need to merge.

in effect, IF { Mergefield Name } = "Jo", find "Jo" in column 1 of
worksheet, insert "Bloggs" from column 2 of worksheet.

I have worked out the syntax to be able to pick up an entire named
sheet from excel in my database merge, but cannot seem to get a lookup
type list on a single sheet to work .

Any Suggestions would be gratefully received
Thanks, Bev
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database field in Word to lookup a cell in an excel workbook BeJay Mailmerge 0 June 5th 08 05:03 PM
Database Query on Merge field KarenB Mailmerge 7 April 3rd 06 05:34 PM
Form Letter Mail Merge using field code: {Database} jyan Mailmerge 8 December 19th 05 09:18 PM
Merge data if database checkbox field is True Terry B via OfficeKB.com Mailmerge 1 September 30th 05 02:09 PM
How do I put a picture in a Mail Merge database field. Ring Mailmerge 3 March 16th 05 08:34 AM


All times are GMT +1. The time now is 08:47 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"