Cut and Paste Addresses from Excel Suddenly Limited

flygirl555

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thank you in advance for your time and suggestions.

I am using Outlook 2010 32-bit and have a list in Excel containing ~1350 email addresses for my clients that I regularly email, and my IT department can't figure out the solution. The list is pulled from a reporting system every few days (to account for changes) - but basically, I've been using a similar list for years and have never run into this problem.

Until earlier this week, I was able to copy and paste all of the addresses into the TO, CC or BCC fields. Suddenly on Tuesday, Outlook seems to cut off at a designated point. I know the names are in the clipboard because they paste to a Word document just fine.

We thought it might have been an update installed by Microsoft, but when we rolled back my computer image to last week, it didn't make a difference.

Any thoughts about why this might have happened and how to solve?

Thanks again!
 

flygirl555

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The file has been approx. the same size? There is a limit to the number of characters in the To field. Short aliases and domains will allow more names than long aliases and domains.

How many addresses were cut off?
Hi Diane,

Thank you so much for taking the time to respond.

Ah ha...I think you might have pinpointed the issue!

Yes - the Excel report - even though it is frequently updated - has always had the same number of people through the years, but on January 1 we had a company name change and updated the domain name of some email addresses from an eight-character domain to a fourteen character domain name.

It tends to cut off around 1275 names now.

I can send in two batches, but oh what a mess that will be. Any other suggestions to help solve this problem?

Thanks!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Are some of these names in the GAL? If you use a DL in GAL, Exchange expands it and the only limitation will be what the server imposes, which apparently is more than 1350 names. :)

A dynamic DL in the gal that uses a property - department etc - will be the easiest as it won't need to be updated as long as the AD records are updated.
 

flygirl555

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thanks again Diane. This is SO helpful!

I am going to talk to our IT people to see what it would take to set this up.

At least you've helped me solve my probem and pointed me in the direction for a solution - THANK YOU! :)
 
Top