Good news, this is my first video post, so less typing for me! Bad news, you have to hear my eloquent voice. Regardless, I thought I’d try it out and see how it flies.
So, a requirement popped up to allow the business to store “Contact Us” information in SharePoint and use workflows to manually send emails to the people who submitted the contact information. Very easy.. nothing spectacular. They also wanted the ability to send pre-formatted email templates as responses. Also fairly easy to do creating an SPD workflow for each template, right? Well.. what do you do so that you don’t have to open up SPD every time the user wants to add or modify a template? I came up with the following solution. You could take what I did here and build upon it to make it much more elaborate. I’m sure you could format the emails more professionally. You could auto populate more fields like the subject and signature. Hey, I got it started, you can make it world class.
So, in a nutshell here is what I did:
- 1. Create a list to contain “Contact Us” information
- 2. Create a list to hold “Email Templates”
- 3. Create a manual workflow called “Send Email” in SPD on the “Contact Us” list that has a “Message” initiation variable
- 4. Create one action that sends an email to the email address from the “Contact Us” list and the body of the email is the “Message” from the initiation variable
- 5. Open up the .aspx file for the “Send Mail” workflow and add the “Email Templates” list to it.
- 6. Set up a web part connection between the “Message” initiation variable and the “Email Templates” list
That’s it! nothing earth shattering. So, without further ado, here’s the video. Please let me know your thoughts on whether I should do this more often or make this a one time occurrence.