use mailmerge field value as SQL query condition

[uhhhh]

Hi everybody,

I am fresh here but kindly ask your help on this::help

I have mailmerge field (company name) and I need to select coresponding data from ms access query and insert as a table in word doc.

I have following select code which works:

strSQL = "SELECT * FROM [Ins Data] WHERE Name = 'manualy eneterd company name' ORDER BY Contract_Nr"

I need it dynamicall, like this

strSQL = "SELECT * FROM [Ins Data] WHERE Name = ' MergeField value' ORDER BY Contract_Nr"

I have found that this works on form fields like this, but cant find correct syntax on merge field.:

strSQL = "SELECT * FROM [Ins Data] WHERE Name = '" & doc.FormFields("Name").Result & "' ORDER BY Contract_Nr

Any ideas or workarounds on this?

Thanks in advance.

Karlis