Our database has a large number of constituents with business relationships and a business name of <No Organization Name> because they are self employed or we think they are self employed. Data clean up issues aside, I would like to be able to do an export that replaces <No Organization Name> with blanks when it leaves Raiser's Edge to Excel. I come from a Microsoft Access application background, where something like this was simplicity unto itself, and am finding Raiser's Edge rather limiting! Thanks in advance for any ideas on how to do this! Cathy

Couldn't you simply do a Find and Replace on the relevant column in Excel? Mark -- Mark Pimperton Development Office Loughborough University UK www.lboro.ac.uk/alumni Consultancy: www.mfconnect.co.uk

Of course - but I am searching for the elusive concept of total automation - as someone with programming background, I used to do this with VBA and queries in my Microsoft access apps all the time. I don't want anyone to have to "touch" the export once it is produced. I just want the user to push the proverbial button. I think it can be done with the VBA User field in export, but I am trying to find out how you "connect" the macro to the export so that it runs automatically when the export does. Cathy

Dear Cathy, You are correct that you can use VBA user field in export Macro, however you can manipulate only VBA user field as other export fields are read only during export process. You can define a system wide macro for example Orgname, Here is quick and dirty code for the same Public Sub Orgname(oRow As IBBExportRow) Const Orgname = 4 Cost vba_field = 6 If oRow.BOF = True Then MsgBox "Macro started" ElseIf oRow.EOF = True Then MsgBox "Macro over" Else If oRow.Field(Orgname) = "" Then oRow.Field(Vba_field) = "" Else oRow.Field(Vba_field) = oRow.Field(Orgname) End If End If End Sub You can write your custom/calculated value on VBA user field but user will get organization name as <No Organization Name> on default organization name field. Since you are from Access background, it would be pretty easy for you to achieve this, you can refer vba.pdf file in Help subfolder of Raisers edge installation for detailed help. Have a great day! Sincerely, Dinesh --------------------------------------- Greytrix Blackbaud Development Partner [Email Removed] ---------------------------------------