Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2022, 03:47 PM
dylansmith dylansmith is offline How to make Outlook auto-detect email addresses pasted from a table Windows 8 How to make Outlook auto-detect email addresses pasted from a table Office 2013
Optimizer
How to make Outlook auto-detect email addresses pasted from a table
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default How to make Outlook auto-detect email addresses pasted from a table


When copying a long column of email addresses from a table & pasting it into the To: bar in Outlook, all the email addresses will STICK TOGETHER. Is there a quick way to separate them so that Outlook can recognize individual addresses?
Reply With Quote
  #2  
Old 06-10-2022, 03:36 AM
rollis13's Avatar
rollis13 rollis13 is offline How to make Outlook auto-detect email addresses pasted from a table Windows 10 How to make Outlook auto-detect email addresses pasted from a table Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

If the data has an e-mail format, when you copy by column Outlook automatically detects and separates adding the ";" when you click some other field.
If you copy by row (data side by side), automatic detection will not occur.
Reply With Quote
  #3  
Old 06-11-2022, 03:45 AM
dylansmith dylansmith is offline How to make Outlook auto-detect email addresses pasted from a table Windows 8 How to make Outlook auto-detect email addresses pasted from a table Office 2013
Optimizer
How to make Outlook auto-detect email addresses pasted from a table
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

Quote:
Originally Posted by rollis13 View Post
If the data has an e-mail format, when you copy by column Outlook automatically detects and separates adding the ";" when you click some other field.
If you copy by row (data side by side), automatic detection will not occur.
the table is in the email itself. I copied the email column & pasted over in the To: field + clicked away, but it didn't separate them automatically.
Reply With Quote
  #4  
Old 06-11-2022, 05:53 AM
rollis13's Avatar
rollis13 rollis13 is offline How to make Outlook auto-detect email addresses pasted from a table Windows 10 How to make Outlook auto-detect email addresses pasted from a table Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

Ok, I now realize what you are doing. I was pasting directly from an Excel table (or list), but it's the same.
If I first paste to the Body of an email and then select a column and Copy/Paste to address fields the email addresses are pasted one under the other and separate when I click away.
Tried in many ways, in some cases had to insert an empty column on the right of the email column then select both and do Copy/Paste/Click away.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Outlook auto-detect email addresses pasted from a table vba detect first char in line and auto insert table Rogireus Word VBA 4 10-24-2019 05:25 AM
Lack of email addresses auto-populating LarryK Outlook 0 10-10-2012 08:09 AM
Outlook unwanted email addresses Jackdeanperry Outlook 0 12-20-2009 11:28 AM
How to make Outlook auto-detect email addresses pasted from a table Extracting email addresses from the BCC in an outlook msg pavinm@hotmail.com Outlook 2 12-14-2009 12:40 AM
How Many Email Addresses Can You email at one time in Outlook zinfandel72 Outlook 2 08-04-2008 06:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft