Passing data from Word form to Excel

[TimGoff]

Hi,

I have a form in Word XP with various text and checkboxes. The only way it appears you can name these is through the bookmark property of each.

I would like to pick up the value of each bookmark and populate an Excel spreadsheet, but it continues to populate the cells with the name of the bookmark rather than the value.

I've tried...

Me.Bookmarks!Bookmarkname
Me.Bookmarks("Bookmarkname&quot
Me.Bookmarks("Bookmarkname&quot.Value

With no success.

What am I doing wrong?!

Thanks in advance

Tim

 

[lespaul]

Try

Me.Bookmarks("BookmarkName&quot.Result Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned