PDA

View Full Version : Outlook VBA Form Help



XopieX20
03-08-2014, 09:02 AM
OK, here is what I need to do. When someone sends an email with the subject "AOR" a form comes up, they fill it out and hit OK, the info gets put in the email and sends it.Steps: Put email address TOSubject: AORClicks SendThis brings up a form to fill out.They fill it outClick SendThe data from the form gets put in that email and sends it.Is this even possiable? I have very little VBA skills, so any help would be great. Thanks,

westconn1
03-08-2014, 03:39 PM
Is this even possiable?probably

but it may be better just to use a designed mail item form

XopieX20
03-09-2014, 09:37 AM
probably

but it may be better just to use a designed mail item form

Well I thought about that, but this is going to be used for over 100 people. So trying to get the form on all the pcs and actually have them use the form when they need to would be very difficult.....

westconn1
03-09-2014, 03:55 PM
you can use the itemsend event to fill in all parts of the message, if the subject matches your criteria
so show a user form then put the values entered (and validated) into the message

you would still need to distribute the userform and also the code, possibly in an addin