Individual E-mails from Distribution List

[LMS]

New Question:

Is there a way to create a distribution list of contacts and when you email using that distribution list, it sends an email to each contact individually in the To bar, and not showing the whole list etc.

And please remember my last question as well.

Thanks much.

 

[Diane Poremsky]

That would be a mail merge... you could do it using code, but I'm not sure of the practicality of it unless you create a template and use it for the email content or are sending a short message. Actually, you could use a userform to supply the content of the body and subject.

Select the Contact Group / DL and run this - but do it with a short DL since it will open a new message to each address.

Sub group_merge()

Dim o_list As Object

Dim objMsg As MailItem

' select or open the distributionlist

Set o_list = GetCurrentItem()

For i = 1 To o_list.MemberCount

Set objMsg = Application.CreateItem(olMailItem)

With objMsg
.To = o_list.GetMember(i).Address
.Subject = "Test Subject"
.Body = "Message Text"
.Display

End With

Set objMsg = Nothing


Next

End Sub

 

[LMS]

Is there way that tihs code can go directly to the email template I want to use?

 

[Diane Poremsky]

It would need tweaked to use as code behind a form, but yes, it should work.

- - - Updated - - -

On second thought, no, not if you want to pick up the members of the contact group.

 

[LMS]

so no way to do it

 

[Diane Poremsky]

For this particular thing, no. Sorry.