Not sure if the macro is resolved at the time of the email being composed. You can try a workaround by adding a hidden field to the form - the default value of this field will be the query string macro. And then, in the notification email just use the value of this hidden field.