Hi,

how would I write a custom script to pull data from a single database with about 20 fields and insert a few of them into various places in a templated text file to prepare invoicing for clients at the click of a button?

I got as far as generating the email, but can't merge the data correctly yet.

I also need to know how to pull in another piece of data depending on what payment method the client happens to have so we can give specific instructions in the email/

thank you

Scott

You might check out this custom function: http://www.seedcode.com/support/viewtopic.php?t=229

With some judicious tinkering, it could allow you to format a very nice email message using a template of your own design.

HTH!