Hi all, I am trying to figure out how I could put the result of a query into a subject in a concatenate way.
Exemple:
query1
PO Supplier
1256 46
4587 46
8945 46
So the subject line would be "PO 1256-4587-8945"
I don't know enough coding to make this work, but I'm sure it can be done, prolly by mixing a DAO recordset and a concatenate of all the line in it.
Just need this part of the code, I can do the rest after to put it into a mail on the subject line using sendobject.
Btw, there is a maximum of 3 PO on each mail I send, and a minimum of 1
Thanks,
Haerion
Exemple:
query1
PO Supplier
1256 46
4587 46
8945 46
So the subject line would be "PO 1256-4587-8945"
I don't know enough coding to make this work, but I'm sure it can be done, prolly by mixing a DAO recordset and a concatenate of all the line in it.
Just need this part of the code, I can do the rest after to put it into a mail on the subject line using sendobject.
Btw, there is a maximum of 3 PO on each mail I send, and a minimum of 1
Thanks,
Haerion