CyberSkills E-Course Lesson #09

And not be consumed in the process.

· You’ll start making and keeping more money and get on the path to financial independence.

You are worth more than you're making.

· You’ll have a lot more sustainable energy.

No more chugging along.

· You'll have a balanced life that works well.

You design it.

· You'll take more, better and smarter actions.

You set the goals you want.

· You'll make better decisions because you can run your ideas by an objective listener.

Your focus will be clear.

Cyber Skill #9

Merging emails into a single text file

Introduction
You may NEVER have a reason to use this skill, but if you receive lots of emails from people giving you feedback, you run an R&D Team, or you are taking a poll and want to merge the content from each of those individual emails into a single text-only email; then you will LOVE this Certified Cyber skill. When I figured this out, it saved countless hours of cut and paste, given the high volume of email I have and the need to consolidate the comments, and produce an ebook, reports or checklists.

You can use this Cyber Skill to merge as few are 5 emails or as many as 500 (and probably more).

Note: This feature is only available with Outlook (not Outlook Express) and you may want to have the original CDs nearby because you may be prompted to 'install' this feature because it doesn't normally install itself when you install Outlook or Office.

Step 1
Launch Outlook (not Outlook Express)

Step 2
Select File>Import and Export

Step 3
Select Export to a file and click Next

Step 4
Select Tab Separated Values (Windows) and click Next
You may have to scroll down to view this option.

Step 5
Select which Outlook folder you want to merge
In other words, you need to have moved/organized all of the emails you want merged into their own folder in Outlook before you reach this step. You will be merging all emails in this folder. FYI, the contents from any files attached to those emails in this folder will NOT be merged into the resulting text file. For these, you may want to open each attached file, and cut and paste the contents into a text-only email that you send to yourself and then, once received, move these to the right folder and then merge the entire contents of that folder.

Step 6
Type in the name of text file you want the emails to be merged into.
This should be a new file meaning it's fine to type in the file name here -- the system will create this file for you. Then, Click Next.

Step 7
Click on the box circled in red below.
Sometimes when you click on the box, the next dialog box appears (see next step). Sometimes, you have to click on Map Custom Fields (in green) first. Sometimes when you click on the box other dialog boxes come up -- just close them. (Wish I could explain -- I use this feature a lot and it seems to operate a little differently each time. What you want to get to is the dialog box illustrated in the next step.)

Step 8
Click and drag-right what you want saved, and Click OK.
This is important. As you can see below, I only dragged the Body of the emails to the right side because I don't need to know the name or email address of who sent in the R&D suggestion emails. I just want the content. But if you want more than just the body, click and drag-right anything else you want to be merged in the final text file, such as "From: (Name)" which is the name of the person who sent an email, "From: (Address)" which is their email address, etc.

Tip: Say you want to merge just the content/body, but also want to send everyone a thank you. Simply repeat this entire lesson - first by creating text file with just the body/content. Then later, just drag-right "From: (Address)" and save that as a different text file -- it will contain ONLY the email addresses of everyone who sent you emails on the topic in this folder in Outlook.

Step 9
Click Finish
Make sure it's what you want.

Step 10
Open up the file you saved
Make sure it's what you want.

You're done!

Was something not clear? Was there a typo or other error?
While we aren't able to provide 1-1 tech support, please email confusion-questions-corrections-improvements to reply@coachbrian.com. Again, we won't reply to your email but it will be read and this course will be improved as a direct result of your assistance.