I have a macro setup so that I can send an email of an invoice report to a customer. I want to be able to personalize the email a bit and add their name into the Message Text field of the EMailDatabaseObject. I want it to say "Dear Bob, Thanks for your order! Here is a copy of your invoice." Of course Bob would could be a different name depending on which invoice report I have open at the time.
The report is based a query called "Search Invoices" and the field name I am interested in is called [FirstName] if that helps at all.
I have tried doing something like Dear [FirstName], ... and that just sends the email just like you are reading it now. Anyone have any ideas?