Cut and Paste Addresses from Excel Suddenly Limited

Status
Not open for further replies.

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! :)
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
makinmyway Research Pane in Emails Turns on and Cut Paste Keys then Stop Working Using Outlook 5
N Cut and Paste Taking 25 seconds Using Outlook 0
L Hyperlins within Outlook will not work, I have to cut and paste to internet explorer, how can this be fixed Using Outlook 1
Diane Poremsky Cut the Clutter: Using Exchange Online’s Clutter Folder New Slipstick.com Articles 0
S categories are being cut off after selecting from category pop up form Using Outlook 3
B email getting cut off Using Outlook 9
M Editing tasks: highlight & copy/cut NOT working in Calendar entries Using Outlook 4
L Outlook Contact Short-Cut In a Folder Using Outlook 10
D Frequently used response short cut possible macro Using Outlook 1
B Fonts cut off when composing new email on outlook 2007 Using Outlook 1
J CPA cuts off left edge of printed Calendar. Ex. January the J is cut off. Calendar Printing Assistant 11
R Outlook Calendar - Directly typing in to quick-create reservations often get cut off. Buggy. Using Outlook 1
A User reports that tasks are cut short - contain only 4kb where they used to contain much more info... Using Outlook 5
M unable to send receive emails after power cut isp details checked and ok Using Outlook 2
R Outlook 2010 hyperlinks getting cut Using Outlook 2
P Add Paste Unformatted to QAT Using Outlook 1
B Paste formatted text (bold, underlined and in quotes) Outlook VBA and Custom Forms 1
O Macro - paste as plain text Outlook VBA and Custom Forms 2
D Paste Excel table into Outlook message Outlook VBA and Custom Forms 6
O How to paste website content using a specific font and removing URLs Using Outlook 2
D Outlook macro with today's date in subject and paste clipboard in body Outlook VBA and Custom Forms 1
K Paste from Windows Clipboard then change font without losing formatting Outlook VBA and Custom Forms 1
N Paste content to Excel when .txt file (attachment) is opened Outlook VBA and Custom Forms 1
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
Diane Poremsky Paste clipboard contents using VBA New Slipstick.com Articles 0
A Outlook: copy & paste Outlook VBA and Custom Forms 9
V Copy and paste body and subject and send multiple emails Outlook VBA and Custom Forms 3
G outlook 13 copy & paste without losing formatting Using Outlook 1
C Copy Cell value from Excel and paste into current email Outlook VBA and Custom Forms 10
R Copy/paste mailing address Outlook 2013 Using Outlook 6
D Open attached CSV, copy newdata and paste it to database CSV Outlook VBA and Custom Forms 2
O Copy email content and paste into new Word Document using a different font Using Outlook 1
L Outlook 2007 Delete and Paste Between Fields Using Outlook 25
L "sometimes" cant send mail, we have to copy and paste the message and resend? Using Outlook 2
I Clipboard paste in macro Using Outlook 14
S I'm not able to copy and paste on outlook. Using Outlook 1
M Outlook 2007 Copy-Paste problems Using Outlook 6
F I cannot highlight text in Microsoft Outlook 2010 e-mails, and copy/paste to the body of another e-m Using Outlook 3
J cannot copy and paste while in list view in-cell editing Using Outlook 1
N Cannot paste image in the body of an email, it will only attach it as a file. Using Outlook 4
J How to copy and paste in Outlook 2010 ? Using Outlook 3
S Copy/Paste from Office Word 2003 to Outlook 2003 Using Outlook 3
R copying or cutting an appointment to paste it to a different date Using Outlook 1
J OWA copy/paste and drag/drop Question Exchange Server Administration 2
J asking again, why am I getting weird thing when I want to paste in email? Using Outlook 6
D Problem with Microsoft Office 2010 Clipboard (Copy and Paste) Using Outlook 1
O How do I copy and paste calendar dates in 2010 outlook? Using Outlook 1
I Office 2003 Crashes when trying to Copy, Paste, or Save with Windows 7 Professional Using Outlook 4
Similar threads


















































Top