valendj
03-16-2011, 11:55 AM
Hi,
I have been trying to figure this one out and I don’t have a clue so I am trying Vbax. I am not a programmer by any means. I have a macro in the attached file already that will send a email to a mailing list that I have set up. But what I need now is for this button that I have set up to send a email to a few people (Up to 3 people) based on which section the inspector used. For example Part number 123456 belongs to section 7501 so, the engineer and supervisor would get a email. This needs to be variable meaning I may have a list of 50 emails on the file in which the macro will pull the email for the section being requested. Also that button would print a ticket or sheet titled “Ticket” . Hopefully, I am making sense. Thank you in advance for any help or suggestions.
I have been trying to figure this one out and I don’t have a clue so I am trying Vbax. I am not a programmer by any means. I have a macro in the attached file already that will send a email to a mailing list that I have set up. But what I need now is for this button that I have set up to send a email to a few people (Up to 3 people) based on which section the inspector used. For example Part number 123456 belongs to section 7501 so, the engineer and supervisor would get a email. This needs to be variable meaning I may have a list of 50 emails on the file in which the macro will pull the email for the section being requested. Also that button would print a ticket or sheet titled “Ticket” . Hopefully, I am making sense. Thank you in advance for any help or suggestions.