I need help creating a macro that emails out what is on a form. Here is what I want to happen. In my form I have a "assigned to" button on the assigned to its a drop down and you can pick a name that comes from a contacts table. In the table they have an email address section. is there anyway that when they submit a new action item the macro will get the email address of the person it was assigned to and then email them the information to let them know they had an action item assigned to them. Im not even sure where to begin with this..