We do not use mail to produce our rather complicated acknowledgements. We export the file into an access database and using microsoft word perform a conditional mail merged based on fields created in the access database. I would like to be able to capture the gift ids of the gifts being acknowledged at some point in the process so the acknowledged flag on the gift can be automatically set to acknowledged. My preference would be to capture the id and change the flag as the file is being exported using VBA. Has anyone done something similar or have any ideas on how this could be accomplished.. We have the vba module, but not the api.

You could either do the whole thing in VBA, ie write all details (including Gift Id) to an Access (or SQL Server) table via ADO, then update the flags after the user signals all is well, or Use the VBA macro Field facility from within RE to add a field to each row of the export (or carry out some action - like setting an acknowkedgement flag - for each row of the export). See Query and Export macros in the VBA/API help. Have fun.

You could use VBA to solve this using the VBA Field to set the acknowledged flag when you do a the Export to Word. Alternatively you could simply continue as you are doing now but also run the mail acknowledgements without using the document so that it acknowledges the recipients. It is clearly a two step process but it would avoid the need for VBA if you feel you don't want to use it David Zeidman Development http://www.zeidman.info