Outlook issue

[DarrenC]

I have over 3,000 emails archieved within Outlook from the past few months.

Within the content of the email is an email address, which I want to add to a MS Excel spreadsheet.

What I have started to do is go through each email copy and paste the email address into MS Excel.

Is there an easier way of doing this task? I think not, but I suppose I'm hoping some brightspark could help me with a better solution.

Darren

[Kalina]

What a daunting task! I'd rather shoot myself.

[DarrenC]

Thanks for the help Colleen

I've a long term solution, but for the 3,000 emails I'm having to go through each one to get the email address

[Abhishek]

It's saved under Contacts right ???
Try this ...
1. In Outlook, on the File menu, click Import and Export.
2. Click Export to a file, and then click Next.
3. Click Microsoft Excel, and then click Next.
4. In the folder list, click the Contacts folder, and then click Next.
5. Browse to the folder where you want to save the contacts as an Excel file (.xls).
6. Type a name for the exported file, and then click OK.
7. Click Next.
8. To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields.
9. Click Finish.
In the MAP Custom Fields, select only email address and you should be fine !!!
Hope that helps ...
Abhishek

[Louis]

Oh boy, The email is in the body of the message?

Is the format of those emails "standard" (all the same). If so a VB script could do this for you but otherwise, the hard part is finding the email in the message.

Well maybe not that much hoping you have only a single @ sign in the message body.

1) Open email
2) locate @
3) Find leading space character, find ending space character
4) Copy and paste into Excel
5) Restart from the beginning with the next email

I'm not very familiar with VB (only did a few minor stuff a while back) but it could be doable.

[DarrenC]

Originally Posted by Abhishek

It's saved under Contacts right ???
Try this ...
1. In Outlook, on the File menu, click Import and Export.
2. Click Export to a file, and then click Next.
3. Click Microsoft Excel, and then click Next.
4. In the folder list, click the Contacts folder, and then click Next.
5. Browse to the folder where you want to save the contacts as an Excel file (.xls).
6. Type a name for the exported file, and then click OK.
7. Click Next.
8. To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields.
9. Click Finish.
In the MAP Custom Fields, select only email address and you should be fine !!!
Hope that helps ...
Abhishek

Thanks, but nope its text within an email.

[Kalina]

Originally Posted by DarrenC

Thanks for the help Colleen

I've a long term solution, but for the 3,000 emails I'm having to go through each one to get the email address

Well at least I bumped your thread honey, how can I help when I have no clue? I just like following you around.

Ohlala, congrats on a 1,000 posts Darren! When was 1,000?

[DarrenC]

Originally Posted by Louis

Oh boy, The email is in the body of the message?

Is the format of those emails "standard" (all the same). If so a VB script could do this for you but otherwise, the hard part is finding the email in the message.

Well maybe not that much hoping you have only a single @ sign in the message body.

1) Open email
2) locate @
3) Find leading space character, find ending space character
4) Copy and paste into Excel
5) Restart from the beginning with the next email

I'm not very familiar with VB (only did a few minor stuff a while back) but it could be doable.

Thanks Louis - yep, I'm doing Control + F to find the @ then copying and pasting the email address into excel. I'm not too hot on VB, which I suppose I should be since I've a Microsoft qualification

[DarrenC]

Originally Posted by Colleen

Well at least I bumped your thread honey, how can I help when I have no clue? I just like following you around.

Ohlala, congrats on a 1,000 posts Darren! When was 1,000?

Colleen, and it's usually me stalking you Wow 1,000 posts, never realised Thanks for bumping my thread, I'll repay you later

[Kalina]

Originally Posted by DarrenC

Colleen, and it's usually me stalking you Wow 1,000 posts, never realised Thanks for bumping my thread, I'll repay you later

I can pretend I stalk... Oooohh can't wait.

[Abhishek]

I can give ya two suggestions,

• Get a coder to write a plugin that looks for the "*@*.tld" variable and indexes it for you.
• Pay a data entry worker to do it for you.

Abhishek

[DarrenC]

Originally Posted by Abhishek

I can give ya two suggestions,

• Get a coder to write a plugin that looks for the "*@*.tld" variable and indexes it for you.
• Pay a data entry worker to do it for you.

Abhishek

Yeah, I am thinking of getting my virtual assistant to do this for me - would be cheaper and quicker than me spending time doing it!

[Abhishek]

Yes you're right, but then user emails are delicate issues, so make sure your virtual assistant doesnt keep a copy and sell it to spammers, coz in the end you might get into trouble!
Abhishek

[DarrenC]

Originally Posted by Abhishek

Yes you're right, but then user emails are delicate issues, so make sure your virtual assistant doesnt keep a copy and sell it to spammers, coz in the end you might get into trouble!
Abhishek

Very good point - Thanks.

Thankfully, I've used her company for years, so I have full trust.

[Abhishek]

Then it's perfectly allright, what on earth are you waiting for ?? hehe!
Best of Luck!
Abhishek