Update query for Quickbooks from SQL using QODBC

I am trying to run an update query from SQL Server 2008 to update a table in QuickBooks Enterprise 12 that is setup as a linked server using QODBC.
My Query:

Update openquery(QUICKBOOKS,'select ToBeEmailed from invoice where customerreffullname = database.dbo.dbtable.emailedcustomerid) set ToBeEmailed = '1'

Every month manually selecting tobeemailed for each invoice waste several days. I would like to setup a stored procedure that sets this from a table that has the list of customers that need to be emailed. I have also tried a simple query removing the table link to update just a single customer and it does not work.
Running the following returns one record with the customer I entered:

select * from openquery(QUICKBOOKS,'select * from invoice where txndate ={d''2013-06-01''} and customerreffullname = ''Customer Name''')

But running an update for even the single customer does not work, I have also tried putting the update query within the openquery.


update openquery(QUICKBOOKS,'select ToBeEmailed from invoice where txndate ={d''2013-06-01''} and customerreffullname = ''Customer Name''') set ToBeEmailed = '1'

This returns the following error:
OLE DB provider "MSDASQL" for linked server "QUICKBOOKS" returned message "[QODBC] Column not found: ToBeEmailed"

How can I get this to not only update but use the customerid from another SQL table in my database?
Any help is much appreciated, thanks.