I need to create a distribution list for a mailing to all my employees. The
e-mail need to be sent to proximally 3,500 employees and unfortunately the
distribution list only lets me input 90 e-mail addresses. This is something
I need to do regularly and due to High turnover I cannot use the same list
twice. Is there any kind of work around that I can create a distribution
list from an excel spread sheet that has 3,500 employees e-mail address. Any
one that can help with this issue will become a person god to me. Thank you

If you can't use the same list twice, then a distribution list is the wrong solution. Instead, consider using a mail merge with the Excel sheet as the data source to send individual messages. I know 3500 messages sounds like a lot, but Word+Outlook can handle it. Plus, you'll be able to personalize the messages to make it more likely that they get read.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"John G Dobbs" <John G (E-Mail Removed)> wrote in message news:03F986E7-90CD-4042-AB55-(E-Mail Removed)...
>I need to create a distribution list for a mailing to all my employees. The
> e-mail need to be sent to proximally 3,500 employees and unfortunately the
> distribution list only lets me input 90 e-mail addresses. This is something
> I need to do regularly and due to High turnover I cannot use the same list
> twice. Is there any kind of work around that I can create a distribution
> list from an excel spread sheet that has 3,500 employees e-mail address. Any
> one that can help with this issue will become a person god to me. Thank you

I looked into that and it seemed like would work but I had a problem when it
came to sending the e-mail out I don’t want to be clicking send on every
single e-mail and I couldn’t get the merge to fill in the To field in the
e-mail? Any thought

"Sue Mosher [MVP-Outlook]" wrote:

> If you can't use the same list twice, then a distribution list is the wrong solution. Instead, consider using a mail merge with the Excel sheet as the data source to send individual messages. I know 3500 messages sounds like a lot, but Word+Outlook can handle it. Plus, you'll be able to personalize the messages to make it more likely that they get read.
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "John G Dobbs" <John G (E-Mail Removed)> wrote in message news:03F986E7-90CD-4042-AB55-(E-Mail Removed)...
> >I need to create a distribution list for a mailing to all my employees. The
> > e-mail need to be sent to proximally 3,500 employees and unfortunately the
> > distribution list only lets me input 90 e-mail addresses. This is something
> > I need to do regularly and due to High turnover I cannot use the same list
> > twice. Is there any kind of work around that I can create a distribution
> > list from an excel spread sheet that has 3,500 employees e-mail address. Any
> > one that can help with this issue will become a person god to me. Thank you
>

Use HTML as the outgoing message format.

Office version?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"John G Dobbs" <(E-Mail Removed)> wrote in message news:F6D7E8BD-83A0-45E5-86BA-(E-Mail Removed)...
>I looked into that and it seemed like would work but I had a problem when it
> came to sending the e-mail out I don’t want to be clicking send on every
> single e-mail and I couldn’t get the merge to fill in the To field in the
> e-mail? Any thought
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> If you can't use the same list twice, then a distribution list is the wrong solution. Instead, consider using a mail merge with the Excel sheet as the data source to send individual messages. I know 3500 messages sounds like a lot, but Word+Outlook can handle it. Plus, you'll be able to personalize the messages to make it more likely that they get read.
>>
>> --
>> Sue Mosher, Outlook MVP
>> Author of Configuring Microsoft Outlook 2003
>> http://www.turtleflock.com/olconfig/index.htm
>> and Microsoft Outlook Programming - Jumpstart for
>> Administrators, Power Users, and Developers
>> http://www.outlookcode.com/jumpstart.aspx
>>
>>
>> "John G Dobbs" <John G (E-Mail Removed)> wrote in message news:03F986E7-90CD-4042-AB55-(E-Mail Removed)...
>> >I need to create a distribution list for a mailing to all my employees. The
>> > e-mail need to be sent to proximally 3,500 employees and unfortunately the
>> > distribution list only lets me input 90 e-mail addresses. This is something
>> > I need to do regularly and due to High turnover I cannot use the same list
>> > twice. Is there any kind of work around that I can create a distribution
>> > list from an excel spread sheet that has 3,500 employees e-mail address. Any
>> > one that can help with this issue will become a person god to me. Thank you
>>

I got it work like a charm only down fall is that it bogs down my computer
for little bit still alot faster then creating 40 distrabution lists

"Sue Mosher [MVP-Outlook]" wrote:

> Use HTML as the outgoing message format.
>
> Office version?
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "John G Dobbs" <(E-Mail Removed)> wrote in message news:F6D7E8BD-83A0-45E5-86BA-(E-Mail Removed)...
> >I looked into that and it seemed like would work but I had a problem when it
> > came to sending the e-mail out I don’t want to be clicking send on every
> > single e-mail and I couldn’t get the merge to fill in the To field in the
> > e-mail? Any thought
> >
> > "Sue Mosher [MVP-Outlook]" wrote:
> >
> >> If you can't use the same list twice, then a distribution list is the wrong solution. Instead, consider using a mail merge with the Excel sheet as the data source to send individual messages. I know 3500 messages sounds like a lot, but Word+Outlook can handle it. Plus, you'll be able to personalize the messages to make it more likely that they get read.
> >>
> >> --
> >> Sue Mosher, Outlook MVP
> >> Author of Configuring Microsoft Outlook 2003
> >> http://www.turtleflock.com/olconfig/index.htm
> >> and Microsoft Outlook Programming - Jumpstart for
> >> Administrators, Power Users, and Developers
> >> http://www.outlookcode.com/jumpstart.aspx
> >>
> >>
> >> "John G Dobbs" <John G (E-Mail Removed)> wrote in message news:03F986E7-90CD-4042-AB55-(E-Mail Removed)...
> >> >I need to create a distribution list for a mailing to all my employees. The
> >> > e-mail need to be sent to proximally 3,500 employees and unfortunately the
> >> > distribution list only lets me input 90 e-mail addresses. This is something
> >> > I need to do regularly and due to High turnover I cannot use the same list
> >> > twice. Is there any kind of work around that I can create a distribution
> >> > list from an excel spread sheet that has 3,500 employees e-mail address. Any
> >> > one that can help with this issue will become a person god to me. Thank you
> >>
>