Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BeJay BeJay is offline
external usenet poster
 
Posts: 11
Default Database field in Word to lookup a cell in an excel workbook

Hi all,

Probably very simple query but any help would be great.

Have successfully been able to insert a whole worksheet using database
field into my merge document using the worksheet name as the link to
the data from my progress database - the main data source.

I now to create another database field to merge just 1 cell of data
from Excel.

I.e. where { MERGEFIELD CUSTOMER REF } = A10000 (in progress), find
A10000 in column A(in excel) and insert the value from column B

I can only insert the entire workbook.

Thanks in advance for any help

Cheers, Bev
Reply
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
Import Excel Workbook into word Bill Godwin Microsoft Word Help 1 April 3rd 08 10:13 PM
Word 2000 Merge with Excel Workbook a_ryan1972 Mailmerge 1 February 10th 06 10:50 AM
Update fields of mail merge based on lookup to database [email protected] Mailmerge 2 January 16th 06 06:01 PM
Update fields of mail merge based on lookup to database [email protected] Mailmerge 0 January 16th 06 02:25 PM
Lookup in word to Excel Raj Microsoft Word Help 1 August 19th 05 12:31 PM


All times are GMT +1. The time now is 04:58 PM.

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"