I would like to personally email our invitation codes instead of using the forum feature.
Is it possible to export a batch of codes so I can do this?
you should be able just to populate the GDN_Invitation table, then send them off with a valid link. You would need to generate some unique ids. it depends how you are importing as to how you are doing it.
I would test a few first.
You can run
CREATE TRIGGER before_insert BEFORE INSERT ON GDN_Invitation FOR EACH ROW SET new.Code = uuid(), new.DateInserted = now();
to ensure you get new codes, and dates on insert.
then you can import a csv like so
then you want to send links of this format.
grep is your friend.