I am creating a notification email to go out to the users of my site, to let them know there is a new InfoPath form they need to complete. I understand how to bring in dynamic fields like their name, due date etc, However, I want the actual body of the email to be populated from columns in a specific list, rather than just typing it into the email window in the workflow. (So that we can make it easy for a non-SharePoint user to edit the email content). Can someone advise me on how to do this please?
PS: I am very new to SharePoint/SP Designer, so please be very detailed.
And also if anyone feels like answering this too: I am also trying to find the URL for my InfoPath form to also add to the email - so the recipient can just click on the link and open their personalized form.
Many thanks!