Welcome to Justanswer.com, my name is ***** ***** I will do my best to assist you.
Theres certainly an easier way to do what your doing. let me ask you a few questions to get started.
Do these emails almost always come from the same email addresses or addresses?
The address you are manually copying, is it included in the body of the email or do you mean the senders email address?
When you output them to a clipboard file, where do you put the email addresses after that, into a word document, into another program, into another email?
Ok, let me ask this then. Do these emails arrive inside of a specific email account that only contains these random messages that you need to copy the emails from?
As long as they are all arriving to the same exact email account, that should give us something to work with.
You mentioned each email gets sorted into a folder. The below steps would allow you to perform one simple operation, and you would pull just the email addresses from all emails in that folder and put them into an excel worksheet in one motion.
This would be the most effective if all the email messages were in the same exact folder.. Then youd only have to do this once a day.
Even if you have those messages siphoning into ten different folders, youd still only have to do the following ten times a day ( once for each folder) , and thats better then hundreds~
Now, you may be asking what if this creates duplictaes.. Or what if you need to run this on the same folder each day of the week. You dont want mondays email addresses repeated 5 times by friday. Excel offers an easy way to access the list and clean up duplicate email addresses. To do so, read over the following..
Try this out, if it doesnt work for you or if you dont think it will work for you we can discuss other options.
I strive to provide great service, and greatly appreciate a rating of excellent ( 5 stars ) selected and submitted below this answer or at the top right of the screen. I always answer follow up questions.Dustin S.Senior Technician and Network Switching Systems Operator / Maintainer.
My apologies, Im going to opt out.
You need someone familiar with vba code usage in outlook and excel~
Hello. My name is***** you still need help with this?
I am back today. I have tried several iterations, but none of them are working on Outlook 2016. I am going to try with 2013 today. There are security restrictions on 2016 that don't exist in 2013, so I think that may be the problem.
I will let you know. Still working on it. It really shouldn't be this difficult, but then again, I guess we can usually say that.
Well, it's a case of absolutely crazy security concerns. They've locked up Outlook so tight, it's barely functional any more.
No. I have something now that will extract the address
Public Sub GetCurrentItem()On Error Resume NextSet ObjSelectedItem = Outlook.ActiveExplorer.Selection.Item(1)If TypeName(ObjSelectedItem) = "MailItem" Then If ObjSelectedItem.SenderEmailType = "EX" Then MsgBox (ObjSelectedItem.Sender.GetExchangeUser.PrimarySmtpAddress) Else MsgBox (ObjSelectedItem.SenderEmailAddress) End IfElse MsgBox ("No items selected (OR) Selected item not a MailItem.")End IfSet ObjSelectedItem = NothingEnd Sub
No. This is just a macro. So you will have to add the developer ribbon through customizing your ribbon. Then under developer, click on visual basic and just paste it in there. Then it will show up under macros. You can also create a button for it so you can just highlight the email and click the button.
This does extract the email, but it doesn't put it in the clipboard. Copying to the clipboard in Outlook will take than an extra hundred lines of code (not exaggerating) because it requires calls to the Windows API. There is no way around this that I can find from within Outlook.
Take a look here:
That will give you the developer ribbon. On that you will have the options for visual basic and macros.
That customize area is the same place you can add a button for a specific macro.
Did you read what I typed to you above?
What I said above was that copying to the clipboard - that step, if done programmatically from Outlook, will take in excess of one hundred lines of additional code.
It can be done, but it would take a considerable additional time investment.
I can probably make that selectable with a reasonable amount of work. But you would have to manually copy it.
Like I said, I could program it to the clipboard, but we'd be talking about a few hours of work.
You can't auto run a macro like that. It just isn't possible within outlook. The best you could do is create a button to click.
That's the best you can get. It cannot be highlighted, but it could be selectable. The challenge is that with anything that simulates interactivity, windows just won't allow it.
It's not mythical. As I said before, you can create it in the same "customize" area of outlook. You would create a button assigned to the macro, just like the macro I gave you, but with selectable text. You could assign it to a keyboard shortcut.
It would appear in your ribbon - you can basically place it where you want.
As the macro is, if you use CTRL+C it will copy the dialog box. Of course, in Windows, nothing can be perfect... it copies the entire dialog. And while you can get rid of the title easily, you can't get rid of the button easily. So you get something like this.
---------------------------Microsoft Outlook---------------------------***@******.***---------------------------OK ---------------------------
Not in the email - it would be in your toolbar.
I've spent a great deal of time on this for you. I am going to opt out at this point.
Hello, my name is, Mike. I see there has been some challenges in trying to solve your issue. It would seem to me the easiest solution would be to configure your mouse so that a single click performs the copy function and another click performs the paste function.
Take a look at these two options and see if they may meet your needs:
I have not tried these personally, because I have never had the same requirement that you have. I merely offered these as suggestions since it seems none of the previous recommended solutions seemed to meet your needs. Your biggest complaint appears to be that there are too many steps you have to do to perform the copy and paste actions that you want to do. Therefore I can only recommend looking for ways to reduce the number of steps. If you want to limit your steps to using the mouse buttons alone then the options I provided could be what you are looking for.
You have had multiple experts attempt to help and neither has had any success. So it is quite possible that you may not find a solution that does exactly what you want it to do.
Yes I use Outlook. But here is what you need to understand about the issue you are encountering. With Outlook it shows email addresses as <*****@******.***> however there are no spaces between the <> symbols and the actual email address. So using simple click to highlight functions wont work because it reads the entire email address as well as the <> symbols all as one. There is no solution that will resolve that. You simply have to click on the inside of < and drag the inside of > then use your copy and past shortcuts.
If you want to copy the email address from the email you received, in Outlook you can mouse over the email address and a pop-up box appears. If you mouse over the the bottom right corner of the pop-up box to the arrow point time down the pop-up box expands. Then mouse over the email address and right click and select copy. This will copy the email address without the <> symbols.
Read my last post. See if that works for you.
You could try exporting your emails to Excel and then simply deleting the data you don't need.