View Single Post
 
Old 07-23-2018, 04:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you open the document and press Alt-F9, you will see the DATABASE field codes, the first of which looks like:
Code:
{DATABASE \d "{FILENAME \p}/../Dummy.xlsm" \s "SELECT `Flat/Door Number`, [Address First Line]&''&[Address Second Line] &''&[District]&', '&[City]&' '&[Postcode] As `Address, Locality & Postcode`, `URC`, `Ref Code`, `Eligibility` FROM [Data$] WHERE [Eligibility] = 'Registered' " \b 58 \l 9 \h }
Simply replace 'Dummy.xlsm' with the correct file name and save the Word document to the same folder as that file.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote