Looking to Create an Email button based on a list criteria

[DefinitelyMaybe]

Hi Guys,

I have a form that is used by 7 business units and email recipients are different. As opposed to creating a form with 7 buttons and writing 'select your business unit', would there be a fairly straight forward way to have a dropdown for business unit and have email button appear for that selection only? And if it's a no-go, any other suggestions would be appreciated!

Thanks



Eric

[pbaldy]

One option would be to have a combo box with the email addresses of the units. The user would pick one and a button could use that address when creating the email. At its simplest:

docmd.SendObject acSendNoObject,,,Me.ComboName,...

[DefinitelyMaybe]

Thanks Paul. Would this work if there were a few email addresses and some on CC for each email?

[pbaldy]

It could, it would just get more complicated. Are they in a table or something? How does choosing a unit determine which address(es) to use?

[DefinitelyMaybe]

I have the emails set up as macros now. So the business unit emails a query that shows a proposed project for approval. Some recipients are the same, some different. I don't want to overcomplicate it. I might just use a tab control so they only see one business unit at a time on the form.

[mike60smart]

Hi
Can you upload a zipped copy of the database?

[DefinitelyMaybe]

Hi Mike
I've had issues emailing due to the company firewall. If I can't I'll create a version with similar situation. I'll post soon. Thanks