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.
Error 29506 when installing 64 bit SQL Server Studio Management Express
March 8th, 2010Adobe Reader PDF changing default Zooms
March 4th, 2010http://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, 2010Speedy 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, 2010Got 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, 2010Error 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, 2010http://www.assistmyteam.net/DocumentExporter/purchase.asp
How to get all emails addresses out of outlook
February 13th, 2010Get 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, 2010Some 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, 2010Paper 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, 2010Hi,
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.