Use Access or Excel as source for Outlook mail message addressees 1

[Roundley]

Hi!

I'm sure that this can be done, but cannot find the first inkling in any Microsoft doco readily available to me.

I have a list of e-mail addresses in Excel (could be Access if needed). I want to be able to collect them all up and stick them in the To: (or cc: or bcc field of a standard message in Outlook automatically and then send the mail. (It's for specific distributions, not a mailing-list substitute.)

Any suggestions on where to look, or nifty code bits I could have?

)

 

[Nikita6003]

Sure:

from Outlook:
1. launch xl
2. launch workbook
3. get email addresses into array
4. quit xl
5. start new mail
6. add addresses from array
7. add message/subject
8. send email

from xl:
1. launch workbook
2. get email addresses into array
3. launch outlook
4. start new mail
5. add addresses from array
6. add message/subject
7. send email
8. quit outlook


Search this forum for examples; thread707-475943 has an emaple bit of code to send an email using outlook from excel (but trust me - there's loads)

HTH

Cheers
Nikki

 

[Roundley]

Thanks, this looks helpful (along with the example code you pointed to). I'll give it a whirl!

) You are never completely useless; you can always serve as a warning to others.