Listbox Selections

[Mikki]

Good Day~
I have a listbox on a form, I want to select either one or all divisions and have a command button email each director a report with just their information but also a company roll-up in the body of the email.

I would like to use VBA.

Any help would be much appreciated.

 

[jdraw]

Do you want to provide some details?
You are talking as if we've been working with you for weeks and know everything you're talking about.
Nobody here is clairvoyant and can not accurately guess what you're talking about. So, if you want help, you are going to have to communicate with readers who know nothing of you, your skills and experience nor your business.

What exactly is the "Business issue/opportunity" you are dealing with in plain English?
Can you post a jpg of your relationships window and the form involved --zip them.

 

[Mikki]

Apologizes.
I want to put each field MH, OR, ORCD, LD, LDCD, LDD, LDDCD based on the divisions selected in the listbox then email them to the individual people's email.

Thank you for responding to my question~mjc