Sending an email to an Outlook distribution list

[Chiggers5]

Is there a way of doing the above? I have several distribution lists (some >100 recipients) defined in Outlook, and would like to use the Docmd.SendObject command to send messages to one or several of them. I cannot find a way of defining a distribution list as any of the To, Cc or Bcc parameters. Does anyone have any suggestions please?

 

[Cronk]

I've not had need to do it, but a contact list is an object in the Outlook model, so you should be able to get to it.

Search on VBA Outlook List object.

 

[Chiggers5]

I've not had need to do it, but a contact list is an object in the Outlook model, so you should be able to get to it.

Search on VBA Outlook List object.

Thanks Cronk; it is just as simple as putting the distribution list name in a string. I was getting an error, but it appears that this was because I had a list named XXX and another called XXX2, and when I specified XXX it couldn't decide which to use. When I renamed the first list XXX1, all was sweetness and light! so this one can be marked closed