Error 29506 when installing 64 bit SQL Server Studio Management Express

March 8th, 2010

For anyone else that needs it spelling out then this is exactly what to do…
For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn’t even know there was a separate version) and then run this as administrator. So I did the following…
1. Right click on desktop and click NEW – SHORTCUT
2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
3. Right click on the new shortcut and Run AS ADMINISTRATOR
4. Enter full path and file name:
e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
Where [YOUR NAME] is the windows user you are using.

Adobe Reader PDF changing default Zooms

March 4th, 2010

http://grok.lsu.edu/Article.aspx?articleId=9242

Adobe Reader 9: Change Default Zoom Options Add to Favorites

——————————————————————————–

By default, Adobe Reader 9 will use the zoom option that is included in the document. If the user desires to automatically have a document zoomed in to a different percentage, follow these steps:

NOTE: This only works if you open a document through Adobe Reader. If you open it outside of Adobe (for example, double-clicking it on the desktop), it will open to the document’s automatic zoom settings.

1. Click Edit and select Preferences.

2. Choose the Page Display category.

3. Under the heading labeled “Default Layout and Zoom,” find Zoom. Choose the desired default zoom option from the menu.

Article ID: 9242
Last Updated: 9/25/2009 11:40:25 AM

——————————————————————————–

PDF “Maximum number of files is already open. No other files can be opened or printed until some are closed”

March 4th, 2010

Speedy Organizer store files that are in PDF format which requires the Adobe Reader to be loaded on your machine. Prior to opening these files, it is a good idea to close any unnecessary applications which should allow more room for you to open more PDF files at one time. When you have reached the maximum files that Adobe Reader will allow to be opened, a window will open stating the following:
“Maximum number of files is already open. No other files can be opened or printed until some are closed”
Select “OK” which will close the window. Double click on the minimized Adobe Reader on the Task Bar at the bottom of your screen. An Adobe Reader window will open. Select “file” then “exit”. This will close all the previously opened Adobe Reader files allowing you to continue opening and reading more files. You can do this as often as necessary.
Also try this link or ask questions directly to the Adobe Forum
http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=22570

Useful Links for Education

February 25th, 2010

Got these from one of my linked in groups thought they were interesting

Subscribe
http://www.fusioncash.net/?ref=joeveloz

http://moneymaking777.blogspot.com/

http://www.getvouchersforfree.com?join=273

http://www.cashle.com/?ref=joeveloz

http://www.textbroker.com/

https://www.mturk.com/mturk/welcome

http://www.demandstudios.com/

These websites have thousands of video lectures from the world’s top scholars.
http://Academicearth.org

http://ocw.mit.edu/OcwWeb/web/courses/av/index.htm

http://worldlibrary.net/Collections.htm

http://freevideolectures.com/

http://videolectures.net/

http://lecturefox.com

http://www.ted.com/

http://OCW.ND.edu
Courses include detailed lecture notes, a calendar of teading assigned for each class and a description of major assignments.

http://OCW.Tufts.edu
Offers student-made documentaries about social issues as well as a list of weekly readings.

http://iTunes.Stanford.edu
Professors Martin Evans and Marsh McCall lecture on great works by Virgil to Voltaire.

http://iTunes.Berkeley.edu
Berkeley’s lectures online

http://WebCast.Berkeley.edu
alternate site of Berkeley’s lectures.

http://scholarspot.com/

http://www.varsitynotes.com/

http://www.learnerstv.com/

If anyone is interested in Entrepreneurship and learning more about what it takes to own or run a business, I highly recommend the Standford eCorner ( http://ecorner.stanford.edu/authorMaterialInfo.html?mid=1554 ) or the Harvard business school ( http://www.hbs.edu/entrepreneurs/ ) podcasts. Both are great resources that provide outstanding insight into running your own business

http://oedb.org/library/features/236-open-courseware-collections

http://www.careervoyages.gov/education-videos.cfm

http://www.sba.gov/tools/audiovideo/deliveringsuccess/index.html

http://www.sba.gov/training/index.html

http://www.sba.gov/tools/audiovideo/Podcasts/index.html

http://www.openculture.com/2007/07/freeonlinecourses.html

http://www.videomd.com/featured_videos.aspx

http://www.freesciencelectures.com/

http://streaming.discoveryeducation.com/

http://education.usgs.gov/common/video_animation.htm

http://www.nachi.org/advancedcourses.htm

http://education-portal.com/video_library/index.html

http://www.serve.org/nche/ibt/aw_video.php

http://www.practisinc.com/interactive/patient-education-videos.php

http://scholarspot.com/

http://www.varsitynotes.com/

http://www.learnerstv.com/

http://www.stumbleupon.com

A link of Educational videos an more..
http://www.ovguide.com/education.html

Laughter is strong medicine for mind and body
“Your sense of humor is one of the most powerful tools you have to make certain that your daily mood and emotional state support good health.”

~ Paul E. McGhee, Ph.D.

Laughter is a powerful antidote to stress, pain, and conflict. Nothing works faster or more dependably to bring your mind and body back into balance than a good laugh. Humor lightens your burdens, inspires hopes, connects you to others, and keeps you grounded, focused, and alert.

With so much power to heal and renew, the ability to laugh easily and frequently is a tremendous resource for surmounting problems, enhancing your relationships, and supporting both physical and emotional health.

I have gathered various videos for your delight and enjoyment we all need it!

http://www.youtube.com/watch?v=p32OC97aNqc

http://www.youtube.com/watch?v=tN3iNxr2bhk

http://www.youtube.com/watch?v=SW3gJFrZ4hY

http://www.youtube.com/watch?v=K_wpunvbyKA&NR=1

Posted 7 hours ago | Reply Privately

Comments (1)

Jose Velasquez
Owner, JDV Telecommunication

See all Jose’s activity »

Stop following Follow Jose
Http://www.ocwconsortium.org/use/use-dynamic.html

An OpenCourseWare is a free and open digital publication of high quality educational materials, organized as courses. The OpenCourseWare Consortium is a collaboration of more than 200 higher education institutions and associated organizations from around the world creating a broad and deep body of open educational content using a shared model.

http://www.oercommons.org/

In a brave new world of learning, OER content is made free to use or share, and in some cases, to change and share again, made possible through licensing, so that both teachers and learners can share what they know.

http://www.schoox.com/

In schooX you can find free online courses in a wide range of subjects. Over 500 online courses, which are soon to reach 2000, are already free available under a Creative Commons license.

http://selfmadescholar.com/b/self-education-resource-list/

The internet is an invaluable resource to self-educated learners. Below is a list of some of the most helpful sites out there including opencourseware materials, free libraries, learning communities, educational tools, and more.

http://www.missiontolearn.com/2009/12/learn-foreign-language-online/

Reading from a textbook isn’t the only way to learn a foreign language. The web offers a number of free tools that can be used to enhance the learning experience inside and outside the classroom. Here are 15 language learning tools to try today:

http://www.rfid4u.com/services/freeelearning.asp

RFID Basics Course
This course helps learners to understand the fundamentals of RFID technology and provides an overview of RFID hardware including different types of tags, tag frequencies, readers, antennas, and so on.

http://www.4shared.com/dir/25834616/400fbf67/sharing.html

http://www.livemocha.com
Posted 7 hours ago | Reply Privately

Problem installing SQL Server Studio Management Express on 64 bit system error 29506

February 23rd, 2010

Error installing SQL Server Management Studio Express on Windows Vista and Windows 7 64 Bit

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/7387d3c1-22c9-4d26-8c0d-a8f8f4c72b36

Saturday, November 18, 2006 2:13 AMmike50
0Sign In to VoteHello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

“Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506.”

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

ReplyQuote Answers
Sunday, December 13, 2009 12:32 AMChris Mck
5Sign In to VoteGuys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

For anyone else that needs it spelling out then this is exactly what to do…
For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn’t even know there was a separate version) and then run this as administrator. So I did the following…
1. Right click on desktop and click NEW – SHORTCUT
2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
3. Right click on the new shortcut and Run AS ADMINISTRATOR
4. Enter full path and file name:
e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
Where [YOUR NAME] is the windows user you are using.Proposed As Answer bysomeonit Thursday, January 07, 2010 4:52 PMMarked As Answer byChunSong Feng -MSFTMSFT, ModeratorThursday, January 14, 2010 9:33 AM
ReplyQuote Monday, November 20, 2006 3:29 AMGlenn WilsonMVP
0Sign In to Vote

You might want to try installing under rasied permissions for the user… Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on….
ReplyQuote All Replies
Monday, November 20, 2006 3:29 AMGlenn WilsonMVP
0Sign In to Vote

You might want to try installing under rasied permissions for the user… Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on….
ReplyQuote Friday, December 08, 2006 9:47 AMAlexejK
11Sign In to VoteI´ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

Proposed As Answer bysquebler Tuesday, August 25, 2009 6:05 AM
ReplyQuote Friday, July 13, 2007 2:02 AMA001122334455
0Sign In to VoteHi…

How can I start a cmd_shell as an Administrator.

thanks
ReplyQuote Wednesday, July 25, 2007 10:17 AMAlexej Kucher
1Sign In to VoteJust right-click the command shell icon and choose “run as…” .Enter the admin credentials.
Proposed As Answer byEliezer Perlmutter Sunday, May 10, 2009 7:16 PM
ReplyQuote Thursday, October 18, 2007 5:25 AMyeyo_all
0Sign In to Vote

hello!

can you help me!

am traing to install SQL server management but an error-code 29506 tells me that it cant install..

i hope that you can help me!

you seed that we can use an cmd-shell, if you can tell me how can i do that it while be very helpful.

my e-mail is yeyo_all@hotmail.com

sorry for my ingles i´m colombian…..
ReplyQuote Sunday, March 09, 2008 6:49 PMDrewCrewOf2
0Sign In to VoteYes this does work – excuse me for being rude but this is a bug that should have been taken care of. I am logged in with a user that has admin rights… that should be enough. All other programs install fine. This needs to be fixed so you MS folks stop driving everyone crazy out here! Dennis from Camarillo CA

ReplyQuote Sunday, March 09, 2008 9:09 PMmarjiemiller
0Sign In to Vote

Thank you for adequately describing my state of mind. I am going crazy. I’m in an endless loop of sql server express saying it won’t work until the upgrade in done, so I do the 2 hour long frigging upgrade, then it says it can’t install, so I reboot and it take forever aftert he bad install, and then it says I have an update again and won’t let me use the sql server express as I have been using it.

I have now missed my deadline today. I have spent the last 3 days fighting this frigging update. I’ve now tried twice to turn off updates. Thanks for ruining my weekend and my presentation Microsoft. I’m going crazy and I still in XP. It did this about a month ago as well. I’m getting really pissed off.
ReplyQuote Wednesday, October 08, 2008 2:41 PMcheeta
2Sign In to Vote

In plane English this means: in the startbar type cmd.exe.

When you see it popping up in the list above, right-click it and click ‘Run as Administrator’.

Then type cd and the path of the folder where SQLServer2005_SSMSEE.msi is located.

Then type SQLServer2005_SSMSEE.msi and press enter.

Worked for me…
Proposed As Answer bynilashis Saturday, March 28, 2009 12:03 AM
ReplyQuote Tuesday, October 28, 2008 12:00 AMSIOK_Online
0Sign In to VoteIt does NOT install on x64 version of Vista, I’ve just found out. The download page says that Vista isn’t supported, btw.

ReplyQuote Tuesday, October 28, 2008 12:06 AMSIOK_Online
0Sign In to VoteBut SP2 version runs! x64 version is 48mb. Downloading now.

ReplyQuote Tuesday, October 28, 2008 9:39 PMscore
0Sign In to Vote

downloaded this SQLServer2005_SSMSEE_x64.msi ran from the command line with admin privs and it worked for me too. thanks!ReplyQuote Sunday, April 12, 2009 7:47 PMMichael Ani
0Sign In to Voterunning from commandline as administrator worked for me too..

thanks…ReplyQuote Tuesday, June 23, 2009 4:27 PMGuffa
0Sign In to VoteI got the same error when trying to install it on Windows 7 RC1.

Starting a console as administrator and starting the installation from there worked fine.
ReplyQuote Wednesday, June 24, 2009 4:43 PMThe G Z
1Sign In to VoteI was trying to install management studio but kept getting the error code of 29506. This happened just before it finished installing.

I just went back to microsoft and intalled sql server management studio “service pack 2″ and it worked no problem.

Hope this helps.ReplyQuote Monday, July 20, 2009 4:50 AMChris.lam
0Sign In to Voteit works if installing sp2 version. thanks!!!ReplyQuote Friday, July 31, 2009 4:40 AMMark D. Albin
0Sign In to VoteWas having the same issue with Windows 7 Ultimate Beta and this worked for installing SQLSERVER2005_SSMSEE_x64.msi.

Thanks!
ReplyQuote Sunday, August 02, 2009 6:14 AMfaithjvp25
0Sign In to VoteWorks for me! Great! ReplyQuote Wednesday, August 05, 2009 4:31 AMNateDood
0Sign In to VoteSame error with Windows 7 –

Did the cmd as administrator and it worked as well.

Quite frustrating considering that I’m already logged as the administrator on my machine. Ridiculous.ReplyQuote Tuesday, August 25, 2009 6:06 AMsquebler
0Sign In to Votealexejk, you’re such a life saver!ReplyQuote Wednesday, August 26, 2009 6:52 AMRayBez
0Sign In to VoteBrilliant, just saved me lots of frustration. It works perfectly on Win7.

As a side note: I found a quicker way than using right click and Run As… is to press Ctrl + Shift + Return when you have entered cmd in the startbar. This will run the prompt with Admin rights.ReplyQuote Friday, September 04, 2009 11:26 PMtheblogmachine
0Sign In to Votethx The G Z !ReplyQuote Sunday, December 06, 2009 10:03 PMsmixe.com
0Sign In to VoteI´ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

u made my day!!!ReplyQuote Sunday, December 13, 2009 12:32 AMChris Mck
5Sign In to VoteGuys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

For anyone else that needs it spelling out then this is exactly what to do…
For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn’t even know there was a separate version) and then run this as administrator. So I did the following…
1. Right click on desktop and click NEW – SHORTCUT
2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
3. Right click on the new shortcut and Run AS ADMINISTRATOR
4. Enter full path and file name:
e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
Where [YOUR NAME] is the windows user you are using.Proposed As Answer bysomeonit Thursday, January 07, 2010 4:52 PMMarked As Answer byChunSong Feng -MSFTMSFT, ModeratorThursday, January 14, 2010 9:33 AM
ReplyQuote Sunday, December 20, 2009 11:21 AMРАМ
0Sign In to VoteThanks for answer, this is working!ReplyQuote Sunday, January 10, 2010 6:35 AMRcALTIN
0Sign In to VoteGuys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

For anyone else that needs it spelling out then this is exactly what to do…
For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn’t even know there was a separate version) and then run this as administrator. So I did the following…
1. Right click on desktop and click NEW – SHORTCUT
2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
3. Right click on the new shortcut and Run AS ADMINISTRATOR
4. Enter full path and file name:
e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
Where [YOUR NAME] is the windows user you are using.

Yes this is works, thanks…ReplyQuote Sunday, January 17, 2010 11:11 AMJoelGlobal
0Sign In to VoteHi Chris:

This seemed to have worked (after hours that ran into days of trying to resolve the problem).
However, after creating the cmd shortcut, here is what occured under two seperate scenarios:
1: If I simply clicked on the shortcut, the following command line appears: C:\Windows\SysWOW64>

2: If I right clicked on it and “Ran As Administrator”, the following command line appears: C:\Windows\system32>

I ran the program as the administrator from the system32 line and it seemed to have loaded correctly.

I’m just curious about how you and others view this somewhat confusing situation and whether or not I need to
somehow load from the “WOW64″ prompt line.

My Operating System is Windows 7 Home Premium 64 bit

Thank you.
JoelReplyQuote Monday, January 25, 2010 4:31 AMMajiktom
0Sign In to VoteWell, trying to install SQLServer2005_SSMSEE_x64.msi.
O/S: WIN7 Pro 64 (fully updated to Jan 24th, 2009)

Created shortcut to cmd64, ran as Administrator.
browsed to SQLServer2005_SSMSEE_x64.msi

Still get error 29506.

I don’t even really need this thing, I’m running down a rathole trying to move a db from C: to D:
I keep getting:
Unable to open the physical file “D:\Data\Databases\Blahblah\Blahblah.mdf”. Operating system error 5: “5(error not found)”.
which is some kind of security permissions issue, but I granted the whole drive to everyone, all users just for fun and still no dice.
You’d think that after so many windows versions, the error message might actually tell you something, rather than having to figure out what Operating system error 5: “5(error not found)” really means. I need to build a database just to store error messages now…

Wasn’t Win7 supposed to be “easy and smart”?

Next I’ll be looking for my old version of DOS3.3, those were the days…

ReplyQuote Monday, February 15, 2010 9:57 PMRon_ATS-LLC
0Sign In to VoteWorked for me as well. Thanks ChrisReplyQuote Saturday, February 20, 2010 8:39 AMbelarussianby
0Sign In to VoteGuys I had a real hard time getting this to work as a newbie with 64 bit computing and not really knowing that much about SQL Server at all.

For anyone else that needs it spelling out then this is exactly what to do…
For Windows 7 64 bit you have to use the 64 bit CMD prompt (I didn’t even know there was a separate version) and then run this as administrator. So I did the following…
1. Right click on desktop and click NEW – SHORTCUT
2. Create shortcut to C:\Windows\SysWOW64\cmd.exe
3. Right click on the new shortcut and Run AS ADMINISTRATOR
4. Enter full path and file name:
e.g. C:\Users\[YOUR NAME]\Downloads\SQLServer2005_SSMSEE_x64.msi
Where [YOUR NAME] is the windows user you are using.
Thanks for your solution. It works perfectly
——————————————————————————–
We can win the raceProposed As Answer bybelarussianby Saturday, February 20, 2010 8:39 AM

Product to export Outlook as PDF

February 18th, 2010

http://www.assistmyteam.net/DocumentExporter/purchase.asp

How to get all emails addresses out of outlook

February 13th, 2010

Get email address of all users from all mails in Outlook Folder
Sometimes you want to send some important notice to everyone who has ever mailed you. Let’s say you have a folder named “Friends” in Outlook where you store all the emails from your friends. Now you want to get all of their email addresses. Pretty difficult work if you have thousands of such mails. Here’s an easy way.

Select the folder in Outlook and press ALT+F11. It will open Visual Basic Editor.
Double click on ThisOutlookSession from the Project tree.
Paste the following function:
Sub GetALLEmailAddresses()

Dim objFolder As Folder
Set objFolder = Application.ActiveExplorer.Selection

Dim dic As New Dictionary
Dim strEmail As String
Dim strEmails As String

Dim objItem As MailItem
For Each objItem In objFolder.Items

strEmail = objItem.SenderEmailAddress
If Not dic.Exists(strEmail) Then
strEmails = strEmails + strEmail + “;”
dic.Add strEmail, “”
End If

Next

Debug.Print strEmails
End Sub

Hit F5 and it will run for a while. Then press Ctrl+G. You will see the email addresses in the “Immediate Window”.

Copy the whole string and you have all the email addresses from all the emails in the selected Outlook folder. There will be no duplicate address in the list.

Published Wed, Aug 9 2006 13:55 by omar
Filed under: scripting
Comments
# re: Get email address of all users from all mails in Outlook Folder
Wednesday, August 09, 2006 9:44 AM by Robert
More better…

Sub GetALLEmailAddresses()

Dim objFolder As MAPIFolder
Dim strEmail As String
Dim strEmails As String
”’ Requires reference to Microsoft Scripting Runtime
Dim dic As New Dictionary
Dim objItem As Object

”Set objFolder = Application.ActiveExplorer.Selection
Set objFolder = Application.GetNamespace(”Mapi”).PickFolder

For Each objItem In objFolder.Items

If objItem.Class = olMail Then

strEmail = objItem.SenderEmailAddress

If Not dic.Exists(strEmail) Then

strEmails = strEmails + strEmail + “;”

dic.Add strEmail, “”

End If

End If

Next

Debug.Print strEmails

End Sub# re: Get email address of all users from all mails in Outlook Folder
Wednesday, August 09, 2006 3:16 PM by JJ
Hey what do I need installed for the script to run? I’m getting a ‘user-defined type not defined’ compile error on the Folder type. I have the Office 2003 Resource Kit and .NET Programmability Support / VB Scripting Support features installed for Outlook.# re: Get email address of all users from all mails in Outlook Folder
Thursday, August 17, 2006 10:47 PM by omar
Which line throws the error?# re: Get email address of all users from all mails in Outlook Folder
Friday, August 18, 2006 1:08 PM by Dinesh Dhamija
First of all, I like your blogs.
Secondly, The code you gave did not work for me, So I chnaged the code a little to make it work.

Here is the updated code.

Sub GetALLEmailAddresses()
Dim objExplorer As Explorer
Set objExplorer = Application.ActiveExplorer()

Dim objFolder As MAPIFolder
Set objFolder = objExplorer.CurrentFolder

Dim dic As New Dictionary
Dim strEmail As String
Dim strEmails As String
Dim objItem As MailItem

For Each objItem In objFolder.Items
strEmail = objItem.SenderEmailAddress

If Not dic.Exists(strEmail) Then
strEmails = strEmails + strEmail + “;”
dic.Add strEmail, “”
End If
Next

Debug.Print strEmails

End Sub

# re: Get email address of all users from all mails in Outlook Folder
Wednesday, January 07, 2009 1:09 PM by Mera Hola
This does not work in Outlook 2007. Do you have an updated code for it?
# re: Get email address of all users from all mails in Outlook Folder
Friday, January 09, 2009 3:48 AM by Jakob H. Heidelberg
Hi, try this code instead (simple version, without the dictionary object)

Sub GetALLEmailAddresses()

Dim objFolder As MAPIFolder

Dim strEmail As String

Dim strEmails As String

Dim objItem As Object

”Set objFolder = Application.ActiveExplorer.Selection

Set objFolder = Application.GetNamespace(”Mapi”).PickFolder

For Each objItem In objFolder.Items

If objItem.Class = olMail Then

strEmail = objItem.SenderEmailAddress

If InStr(strEmails, strEmail) = 0 Then strEmails = strEmails + strEmail + “;”

End If

Next

Debug.Print strEmails

End Sub
# re: Get email address of all users from all mails in Outlook Folder
Friday, January 09, 2009 5:05 PM by christopher
hey the last script from Jacob worked for me great-

how would I change this to grab the CC: addresses as well as the sender addresses??
# re: Get email address of all users from all mails in Outlook Folder
Saturday, January 31, 2009 6:17 PM by Colin Charles
How do I change the script to get all the email addresses for the recepients of all the emails I have sent?
# re: Get ALL email address of all users from all mails in Outlook Folder
Friday, February 06, 2009 3:48 PM by captain-mruphy
This code is so close to exactly what I needed and I thank you guys a lot for putting it together.

However I was wondering if someone could write a few lines into it that would let you select the top folder, and have it recurse down through ever folder nested under that.
# Got email address of all users from all mails in Outlook Folder!
Tuesday, February 10, 2009 12:45 PM by captain-mruphy
Okay guys, I worked on this for a little while and it finnaly works, abate messyness. I found a module to print this to a text file and two moduels for the recursive function: one takes names, e-mail, and subject from each e-mail and makes a list that is pastable into excel. The other makes a list of every e-mail with no duplicates. Choose the one you want call.

‘This is the main Sub, It picks the folder and calls the functions to recurse and save

Sub GetALLEmailAddresses()

Dim objFolder1 As MAPIFolder

Dim strEmail1 As String

Dim strEmails1 As String

Dim objItem As Object

Dim writeText As Boolean

Set objFolder1 = Application.GetNamespace(”Mapi”).PickFolder

strEmails1 = GetMessages(objFolder1, True)

’strEmails1 = GetMessageEmails(objFolder1, True)

Debug.Print strEmails1

writeText = SaveTextToFile(”C:\file.txt”, strEmails1, True)

End Sub

‘this is verbatem from www.freevbcode.com/ShowCode.Asp, it saves the files to a text file

Public Function SaveTextToFile(FileFullPath As String, _

sText As String, Optional Overwrite As Boolean = False) As _

Boolean

‘Purpose: Save Text to a file

‘Parameters:

‘– FileFullPath – Directory/FileName to save file to

‘– sText – Text to write to file

‘– Overwrite (optional): If true, if the file exists, it

‘is overwritten. If false,

‘contents are appended to file

‘if the file exists

‘Returns: True if successful, false otherwise

‘Example:

‘SaveTextToFile “C:\My Documents\MyFile.txt”, “Hello There”

On Error GoTo ErrorHandler

Dim iFileNumber As Integer

iFileNumber = FreeFile

If Overwrite Then

Open FileFullPath For Output As #iFileNumber

Else

Open FileFullPath For Append As #iFileNumber

End If

Print #iFileNumber, sText

SaveTextToFile = True

ErrorHandler:

Close #iFileNumber

End Function

‘This is the GetMessages that takes a folder and returns a list of the “name, e=mail, subject”s

Public Function GetMessages(oFolder As MAPIFolder, ByVal bRecursive As Boolean) As String

Dim objFolder As Outlook.MAPIFolder

Dim strEmail As String

Dim strEmails As String

Dim strName As String

Dim strSubject As String

Dim strAll As String

Dim strItemAll As String

Dim objItem As Object

Dim objFolders As Outlook.Folders

Set objFolders = oFolder.Folders

For Each objFolder In objFolders

For Each objItem In objFolder.Items

If objItem.Class = olMail Then

strEmail = objItem.SenderEmailAddress

strName = objItem.SenderName

strSubject = objItem.Subject

strItemAll = strName + “,” + strEmail + “,” + strSubject

‘If InStr(strEmails, strEmail) = 0 Then strEmails = strEmails + strEmail + “;”

strAll = strAll & Chr$(13) & strItemAll

End If

Next

If bRecursive Then

‘ Might want to compare this to strEmails instead of just appending.

strAll = strAll + GetMessages(objFolder, bRecursive)

End If

Next

GetMessages = strAll

End Function

‘This is the the function that returns a list of “;” delimited e-mails with no duplicates.

Public Function getMessageEmails(oFolder As MAPIFolder, ByVal bRecursive As Boolean) As String

Dim objFolder As Outlook.MAPIFolder

Dim strEmail As String

Dim strEmails As String

Dim objItem As Object

Dim objFolders As Outlook.Folders

Set objFolders = oFolder.Folders

For Each objFolder In objFolders

For Each objItem In objFolder.Items

If objItem.Class = olMail Then

strEmail = objItem.SenderEmailAddress

If InStr(strEmails, strEmail) = 0 Then strEmails = strEmails + strEmail + “;”

End If

Next

If bRecursive Then

‘ Might want to compare this to strEmails instead of just appending.

strEmails = strEmails + getMessageEmails(objFolder, bRecursive)

End If

Next

getMessageEmails = strEmails

End Function
# re: Get email address of all users from all mails in Outlook Folder
Tuesday, May 12, 2009 9:05 AM by Ge
Please help, it won’t work for me. I have outlook 03 and have tried every code to no avail
# re: Get email address of all users from all mails in Outlook Folder
Monday, June 08, 2009 5:19 AM by Jobe
Jakob’s simple version worked perfectly for me in outlook 2007. all other versions with the dictionary object displayed an error. Now to try to get 400 emails into csv format…

THANKS!
# re: Get email address of all users from all mails in Outlook Folder
Wednesday, July 01, 2009 12:22 PM by Prasad
Really helpful to get email ids from my outlook out of hundreds of emails that I receive everyday.

Thanks
# re: Get email address of all users from all mails in Outlook Folder
Tuesday, July 28, 2009 10:52 PM by Andreas
Hello guys, can you modify Jakobs version for me so I can get all email addresses within the email bodies instead of the the “From” field in a selected folder?

I have saved all bounced back emails in a separate folder and want to get now the email addresses that bounced back to clean the OK list.
# re: Get email address of all users from all mails in Outlook Folder
Wednesday, January 27, 2010 11:17 AM by Robin
for Outlook 2000 the attribute objItem.SenderEmailAddress doesn’t exist – just .SenderName, .Subject etc.

Any idea how I can get the email address in OL2000?

Thanks
# re: Get email address of all users from all mails in Outlook Folder
Sunday, February 07, 2010 3:28 PM by Dan
Good code. I use Outlook 2003 and used Jakob’s simple version to pull email addresses from an outlook folder (pasted below). But, I have many sub folders in the Outlook folder. How can the code be modified to automatically search through all the sub folders? Thanks!. Dan

Sub GetALLEmailAddresses()

Dim objFolder As MAPIFolder

Dim strEmail As String

Dim strEmails As String

Dim objItem As Object

”Set objFolder = Application.ActiveExplorer.Selection

Set objFolder = Application.GetNamespace(”Mapi”).PickFolder

For Each objItem In objFolder.Items

If objItem.Class = olMail Then

strEmail = objItem.SenderEmailAddress

If InStr(strEmails, strEmail) = 0 Then strEmails = strEmails + strEmail + “;”

End If

Next

Debug.Print strEmails

End Sub

professions that are on the way out

January 30th, 2010

Some careers have simply faded away over the past 10 years. In most cases, advances in technology eliminated the need for certain jobs. Americans are also more focused on conservation. Here are a few jobs that are being phased out; hopefully your career isn’t on this list!

1. Bank Tellers

While the need for banking services has increased, services traditionally performed by tellers (receiving and dispensing cash, depositing money, etc.) is now performed electronically. The use of ATMs and online banking continues to increase. Tellers are only needed for complex transactions.

More from Investopedia.com:

• 6 Hot Careers With Lots of Jobs

• Dealing With 9 Coworker Personality Conflicts

• 6 Reasons to Make a Lateral Career Move

2. File Clerks

Even the most paper intensive organizations have decreased their use of paper files. Imaging, electronic forms and careful attention to process efficiency reduced the need to maintain paper files. One of the biggest threats to the file clerk occupation is the push toward environmental sustainability (preserving trees by using less paper). The new “file clerk” is a Database Report Writer who knows how to run database queries.

3. Telephone Operators

Even the smallest company can now use sophisticated telephone systems that allow callers to select their own options for needed information. Callers simply listen to pre-recorded telephone directory names and select the person they want to talk to. Voicemail, email and even texting have become preferred forms of communication in addition to traditional telephone conversations.

4. Data Entry Clerks

There is no doubt the amount of data generated over the past decade has swelled. But it was all electronic to begin with, so there’s no need to hire a person to copy it from other sources. The ability to integrate systems and make various systems exchange date automatically also reduced the need to for a person to translate or manipulate data.

Popular Stories on Yahoo!:

• Cities Hit Hardest by Foreclosures in 2009

• Why $25,000 Is the Magic Number for Cars

• The Fastest-Growing Green Jobs

——————————————————————————–
More from Yahoo! Finance

5. Mail Clerks

Yes, there is still plenty of mail, only it’s electronic, so the need for people to sort and distribute paper mail has decreased. Also, bar code readers sort mail and pre-printed postage eliminates the need for weighing and applying postage stickers. Today’s mail clerks have new tools to allow more work to be done with fewer people. (Not all careers are ho-hum. These 10 have a very high percentage of happy employees.

6. Photo Processors

With the prevalence of digital photography, the need for photo processing has greatly diminished. Even people who still choose to print their photos use self-service kiosks. Photo processors who used to run machines in retail stores, as well as in processing centers, are becoming obsolete.

7. Travel Agents

The internet now makes it possible for the public to schedule their own trips. While there are still many travel agents, incentives once offered by airlines, hotels and car rental companies make the occupation less profitable. Today’s travel agents often book long or complicated trips, while the weekend getaway or quick business travel is scheduled individually online.

8. Watch Salesperson

Who needs a watch when your cell phone tells you what time it is 24/7? Everything around you shows the time – most electronic devices have a clock. Even billboards show the current time. Watches and watch salespersons are becoming a thing of the past.

9. Video Store Clerk

Remember the video store? Clerks collected returned video tapes and checked them in. They used to stick the tapes in a re-winder then pluck them back in their cases. Even DVDs are being upstaged by online movie viewing and cable companies with user-selected movies. You can now even watch movies on your video game console. Traditional video stores are going away, and so is the need for workers.

The Bottom Line

The past decade ushered in job market changes that closed out old careers and started new ones. In many cases, the processes performed in old jobs were replaced technology, but in some cases, the processes simply went away. One thing is for sure, there will always be change. The unemployment rate may be high, but that doesn’t mean you need to sit on the sidelines.

What paperwork to toss and what to keep

January 21st, 2010

Paper Records: What to Toss, What to Keep
Laura Cohn, Associate Editor
Tuesday, January 19, 2010
This article is part of a series related to being Financially Fit
You can deep-six most of your documents and go digital with the rest.
Worried about pitching documents that they may need at some point, many people decorate a spare bedroom with boxes or large file cabinets stuffed with old bank statements, tax returns and pay stubs. (Okay, if the stash isn’t in a spare bedroom, perhaps it resides in the attic, basement or garage.) As you finish up your tax return this year, take the opportunity to clean house. With a few key exceptions — mainly tax-related documents — you don’t need to keep all those papers. And if you’re willing to use online banking and create a digital archive of crucial records, you may even be able to go paper-free.
Before you dig into those piles of records and statements, invest in a shredder to guard against identity theft. And don’t skimp on the shredder, or you’ll defeat the purpose of having one. Ribbon-cut models produce bands that can be taped back together. So shell out the money for a cross-cut or confetti model. We like the Fellowes Powershred DS-2 (about $100 online) for its sharp look and munching capability.
What to Keep
The most important documents to hang on to are your annual tax returns. You should keep the actual returns forever, but you can get rid of the supporting documents after three years. That’s how long the IRS has to initiate an audit. If you’re self-employed, you need to keep supporting tax documents for six years (that’s how long the IRS has to come after you). Once the time elapses, toss the records — and shred any that reveal your Social Security number or other personal information.
Other papers to save for at least three years include thank-you letters from charities and year-end investment statements. You don’t need to save your monthly mutual fund reports forever. But before you toss them, wait for the year-end statements and make sure they match up. Also be sure to keep records that show the initial purchase price for stocks and mutual funds so you can calculate your basis when you sell them. After that, you can shred the documents once the three- or six-year IRS window draws to a close.
You also need to save records pertaining to your house as long as you live in it. Records showing your purchase price, and what you spent on improvements, may come in handy when you’re trying to prove the value of your home to potential buyers. Another reason to keep these papers: If you sell your house at a hefty profit (more than $500,000 for couples filing a joint return or $250,000 for single filers), certain expenses can be used to lower your tax bill. After you sell the house, keep the documents for three years.
Finally, hold on to records showing how much money went into and came out of IRAs and 401(k)s — especially if you’ve made any nondeductible contributions — so you don’t overpay taxes when you withdraw the money. Keep any 8606 forms on which you reported nondeductible contributions to traditional IRAs.
What to Toss
So what can you unload? ATM receipts, bank withdrawal and deposit slips, and credit-card receipts can go through the shredder after you’ve checked them against your monthly statements. Rebecca Eddy, founder of Eddy & Schein In-Home Administrators for Seniors, says one client kept every single pay stub she had ever received. That’s overkill. Just keep them until you get your Form W-2. You can also get rid of paper copies of most monthly bills — for credit cards, utilities and cable TV — unless you need them for tax purposes.
If you need help sorting through the clutter, consider hiring a daily money manager. Daily money managers tend to have a background in accounting, finance or law, and they make house calls. You can find one in your area by checking with the American Association of Daily Money Managers. Typical cost: up to $150 an hour.

PDF There was an error opening this document Maximum number of files are open

January 19th, 2010

Hi,

There’s a problem with Acrobat 5.0 which we use in our company. When the
users open up a lot of PDF’s, and then try to open the next one,they get
this error:

“There was an error opening this document. Maximum number of files are
already open. No other files can be opened or printed until some are
closed.”

The user needs to reboot the PC to solve this problem and to open up other
PDF documents. Even closing down all the open PDF’s and deleting the
temporary PDF files created in the temporary folder does not solve this
issue.

Adobe acknowledges this issue and has provided the following information
for Acrobat 4.0:

“NOTE: Please keep in mind that if you open a large number of PDF files
simultaneously, you may run out of system resources.
1. Exit from Acrobat Reader.
2. Make a backup copy of the Acroread.ini, which is in the Windows folder.
3. Open the original Acroread.ini file in a text editing application that
can save in text-only format (e.g., WordPad, Microsoft Word).
4. Locate the Maxopendoc line, then do one of the following:
- Delete the Maxopendoc line. Doing this enables Acrobat to open as many PDF
files as memory allows.
- Increase the number of PDF files Acrobat Reader can open at once by
changing the value specified for the Maxopendoc line to a number greater
than ten. For example, change the line to read: Maxopendoc=20
5. Save the Acroread.ini file in text-only format.”

I can’t seem to find such an INI file for Acrobat 5.0, eventhough they say
there’s one called ABCPY.ini. But I can’t locate this in any of the machines
that we have here that have Acrobat 5.0 installed.

Please provide me with a solution to this problem, so that we can open up
PDF documents without getting this error.