Multiple email Recipients

[Gismo]

See f theDBguy's function works for you.?

http://www.accessmvp.com/thedbguy/codes.php?title=generic

Linked from https://www.access-programmers.co.u...ew-parameters-expected-3.313393/#post-1715056

thank you
will look at it as well

 

[Gismo]

thank you all for the assistance
i managed to get everything working

 

[Minty]

Glad you got things sorted out.
For the benefit of other users seeing the thread, what was the issue?

 

[Gismo]

Glad you got things sorted out.
For the benefit of other users seeing the thread, what was the issue?

for some reason, the query referring to the email addresses in the VBA code sending the mail, should not refer to a Form
I linked the query to a Table and it worked fine