Sending the same e-mail to multiple recipients

G

grangey77

I am a fairly new user to vba in access.

I am trying to create a form that will send the contents of two textboxes
using outlook. this i have done succesfully for one recipient.

the next task i have is to now send the e-mail to multiple recipients
selected from a listbox (all emails have the same @example.co.uk address, so
that is not such an issue)

can anyone offer any advice?

Many thanks
 
G

grangey77

thank you daniel this has helped a great deal, but now i have the list of
names and the prefix how would i go about retrieving the individual names and
sending them individually as i am still not to clear about this
 
G

grangey77

i managed to solve the problem by gererating a while loop using an intra to
trim the values that were not needed. thanks for getting me on the might track
 
Top