Sending the same e-mail to multiple recipients

[Guest]

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

 

[Guest]

http://www.microsoft.com/office/com...1797&mid=c604b457-6e82-49d2-a621-bed3c7b61797

show you how to iterate through the selections made by your user. Simply
concatenate the selections together to build a string that you can use for
your TO input variable to send your e-mail.

 

[Guest]

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

 

[Guest]

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