tag:blogger.com,1999:blog-19287583.comments2019-08-28T18:09:55.641+10:00VBA AdventuresAnonymoushttp://www.blogger.com/profile/15980463719782533046noreply@blogger.comBlogger45125tag:blogger.com,1999:blog-19287583.post-83949173434197049092015-08-21T07:19:23.805+10:002015-08-21T07:19:23.805+10:00Natalie,
Can you be a bit more explicit about you...Natalie,<br /><br />Can you be a bit more explicit about your problem? If you mean the original issue I posted about, as far as I know it has not been fixed but I no longer have that need so can't say for certain.<br /><br />WazzaAnonymoushttps://www.blogger.com/profile/15980463719782533046noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-41375228294976364802015-08-19T00:47:49.271+10:002015-08-19T00:47:49.271+10:00Im also experiencing the same issue so if anyone c...Im also experiencing the same issue so if anyone comes accross a solution please let me know.Anonymoushttps://www.blogger.com/profile/00611925084162841574noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-3262607717986149322013-09-04T23:00:44.967+10:002013-09-04T23:00:44.967+10:00Keep in mind that the FileDialog will show other r...Keep in mind that the FileDialog will show other results depending on the Office product you're working with, e.g. I'm working with Access, but the FileDialog doesn't show the Word extensions, so IsWordFile("doc") results in FALSE.Casparhttps://www.blogger.com/profile/05672369152015238432noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-45245956405392631362013-03-14T07:55:44.487+11:002013-03-14T07:55:44.487+11:00Hi there,
I've just tried to install this, as ...Hi there,<br />I've just tried to install this, as it's almost exactly what I want to achieve, and looks great. But it's not working for me. Can you suggest anything? I've inserted a line <br /><br /> MsgBox "Done"<br /><br />after the line that changes the property, and it doesn't get actioned.<br /><br />My code says <br /> If CheckMessageRecipient(oItem, TC_BAINSWORLD_ACCOUNT, True) Then<br /> ' Yes it was - change the account<br /> Call SetMessageAccount(oItem, TC_PF_ACCOUNT, True)<br /> MsgBox "Done"<br /><br />Thanks in advance...egarobarhttps://www.blogger.com/profile/00261560354823778748noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-76013409805057010722012-06-14T01:44:54.005+10:002012-06-14T01:44:54.005+10:00can you post a sample db for this one? 07 or 10? t...can you post a sample db for this one? 07 or 10? thanks. trying to get it to work but not having any luck.redbananahttps://www.blogger.com/profile/16589304459587203475noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-43346505949681644602012-06-14T01:44:23.366+10:002012-06-14T01:44:23.366+10:00can you provide a sample db for ms access 07 or 10...can you provide a sample db for ms access 07 or 10? thanksredbananahttps://www.blogger.com/profile/16589304459587203475noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-3872818689187472362011-08-06T12:03:37.157+10:002011-08-06T12:03:37.157+10:00Hey - I know I'm posting a comment on an ancie...Hey - I know I'm posting a comment on an ancient blog post, and it's off-topic (but it is still Outlook and vba ; - ), but I can't find any way in code to change move the focus from the Subject on a new mailitem (standard Outlook New E-mail, not a custom form) so that the field will update. Do you have any ideas?Celadhttps://www.blogger.com/profile/14307498932849752918noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-35029282720333492592011-05-18T17:14:47.586+10:002011-05-18T17:14:47.586+10:00Dear Sir,
my website name is www.usemytips.in hos...Dear Sir,<br /><br />my website name is www.usemytips.in hosted on yahoo server and they have alloted me 1000 email ids..and i have email databse in excel.<br /><br />Following are the properties of outlook mail. I have around 35 email ids. I wish to do mass mailing but i can send only 250 email per day / per ID.<br />and every time i need to change out look email properties.<br /><br />i will create one table in excel with following headings.<br /><br />Display Name<br />Email Address<br />Usename <br />Password<br /><br />Is there any option in excel vba where my codes will read from this table and change the outlook properties and send the mail.<br />One its reach to 250 my cursor will move to next row.<br /><br />i have basic knwlege of excel vba<br />would be great help if you share some knowledge.<br /><br />Regards<br />Shankar More<br />shankar.more@lodhagroup.com<br />IndiaKaranhttps://www.blogger.com/profile/09242645628127277672noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-71556141490718727522011-04-28T04:20:13.121+10:002011-04-28T04:20:13.121+10:00Have you been able to figure this out? It has been...Have you been able to figure this out? It has been driving me nuts. Thanks.Barreshttps://www.blogger.com/profile/01668788413865246936noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-17261287675368214242010-07-06T02:38:34.524+10:002010-07-06T02:38:34.524+10:00Thanks was looking for this .....Thanks was looking for this .....Excel VBA Codebasehttps://www.blogger.com/profile/06246169862277066750noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-48301505224532698972010-07-06T02:37:12.774+10:002010-07-06T02:37:12.774+10:00Thanks for sharing...Thanks for sharing...Excel VBA Codebasehttps://www.blogger.com/profile/06246169862277066750noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-21989592769073235042010-04-22T04:08:29.709+10:002010-04-22T04:08:29.709+10:00I'm getting similar issues when trying to call...I'm getting similar issues when trying to call Workbook.Open on a password-protected file on a network. It works fine on a local file, but won't accept the password on a shared drive.Unknownhttps://www.blogger.com/profile/06322389858775392979noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-32425351093363863592010-04-16T14:07:00.646+10:002010-04-16T14:07:00.646+10:00Observant readers will note that this will work in...Observant readers will note that this will work in ANY Office product from version 2002 onwards. There is no intrinsic "Word" feature used...Wazzahttps://www.blogger.com/profile/03487855618160562635noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-85108206559236903052010-03-12T03:54:55.932+11:002010-03-12T03:54:55.932+11:00Awesome Thanks! Just a few minutes of tweaking tnd...Awesome Thanks! Just a few minutes of tweaking tnd there it is!!Goldfingerhttps://www.blogger.com/profile/04340941278089549933noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-43694444770467451132010-02-27T15:48:46.787+11:002010-02-27T15:48:46.787+11:00@Matthew, I don't have any exchange connection...@Matthew, I don't have any exchange connection so not sure what is happening for you. What is the specific error you get?Wazzahttps://www.blogger.com/profile/03487855618160562635noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-20003803878647869652010-02-26T16:47:16.667+11:002010-02-26T16:47:16.667+11:00Awesome! Very handy! (and so many years on from wh...Awesome! Very handy! (and so many years on from when you posted)Anonymoushttps://www.blogger.com/profile/07591938699649956380noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-24134236612965191852010-02-25T21:30:33.642+11:002010-02-25T21:30:33.642+11:00Great thanks, you are a legend, this worked.
I so...Great thanks, you are a legend, this worked.<br /><br />I sometimes have connectivity issues, and the GetInternetHeaders function fails with an Outlook response error, why on earth does it try use my local OST file rather? <br /><br />Regards<br />MattUnknownhttps://www.blogger.com/profile/09184879676971249316noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-87096901245597680172010-02-25T15:03:58.423+11:002010-02-25T15:03:58.423+11:00Matthew,
Yes, since I moved to Outlook 2007, it h...Matthew,<br /><br />Yes, since I moved to Outlook 2007, it hasn't worked properly for me either. When I reply to a message sent to my secondary account, the text at the top of the form says "This message will be sent using the bainsworld account." but if I click on the accounts button, it has the primary account ticked.<br /><br />Your message prompted me to investigate and I have changed SetMessageAccount to use the RDO objects and this now works. See below...<br /><br />Public Sub SetMessageAccount(ByRef oItem As MailItem, _<br /> ByVal strAccount As String, _<br /> Optional blnSave As Boolean = True)<br /><br /> Dim rMailItem As Redemption.RDOMail<br /> Dim rSession As Redemption.RDOSession<br /> Dim rAccount As Redemption.RDOAccount<br /> <br /> ' Use a RDO Session object to locate the account<br /> ' that we are interested in<br /><br /> Set rSession = New Redemption.RDOSession<br /> rSession.MAPIOBJECT = Application.Session.MAPIOBJECT<br /> Set rAccount = rSession.Accounts(strAccount)<br /> <br /> ' Now use the RDO Mail object to change the account<br /> ' to the one we require<br /><br /> Set rMailItem = rSession.GetMessageFromID(oItem.EntryID)<br /> rMailItem.Account = rAccount<br /> If blnSave Then<br /> ' They want us to force a save to the mail object<br /> rMailItem.Subject = rMailItem.Subject<br /> rMailItem.Save<br /> End If<br /> Set rMailItem = Nothing<br /> Set rAccount = Nothing<br /> Set rSession = Nothing<br />End SubWazzahttps://www.blogger.com/profile/03487855618160562635noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-41929219946977375692010-02-17T23:18:19.157+11:002010-02-17T23:18:19.157+11:00Oh and by the way, I had to enable macro's for...Oh and by the way, I had to enable macro's for it to run the code (in the trust center)- maybe a outlook 2007 problem only.Unknownhttps://www.blogger.com/profile/09184879676971249316noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-9619651121746881272010-02-17T23:16:45.461+11:002010-02-17T23:16:45.461+11:00I try debug the code, because it doesn't seem ...I try debug the code, because it doesn't seem to work for me.<br />Should the strAccount in <br /><br />Call rUtils.HrSetOneProp(oItem.MAPIOBJECT, PR_ACCOUNT, strAccount, blnSave) <br /><br />Just be the name of the account I have? It doesn't seem to impact on the account the message is associated with. (By viewing the field "Account" in my message list).<br /><br />If I try get the account name, then it just returns a blank string back (instead of the account name that i can see in my message list). I'm using outlook 2007, any idea?Unknownhttps://www.blogger.com/profile/09184879676971249316noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-17566972170095605912010-01-07T02:05:32.907+11:002010-01-07T02:05:32.907+11:00Thanks !!Thanks !!DATTA BORUDEhttps://www.blogger.com/profile/01766089227884256609noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-75191219159949821242009-03-07T07:13:00.000+11:002009-03-07T07:13:00.000+11:00Note: Outlook 2007 now allows you to flag an emai...Note: Outlook 2007 now allows you to flag an email before you send it, so this code is no longer required...Wazzahttps://www.blogger.com/profile/03487855618160562635noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-36403391028284038912009-03-05T08:15:00.000+11:002009-03-05T08:15:00.000+11:00http://vbaexcel.euI found your webpage very useful...<A HREF="http://vbaexcel.eu" REL="nofollow">http://vbaexcel.eu</A><BR/><BR/>I found your webpage very useful! The link above is to an other site that has good vba code!<BR/><BR/>Thanks!www.randek-bautech.comhttps://www.blogger.com/profile/12710802433940802557noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-36143919169930135662009-02-02T10:26:00.000+11:002009-02-02T10:26:00.000+11:00Prominent Excel MVP Ron de Bruin has confirmed thi...Prominent Excel MVP Ron de Bruin has confirmed this is an error and has notified the Microsoft Excel team. Stay tuned for additional developments.Wazzahttps://www.blogger.com/profile/03487855618160562635noreply@blogger.comtag:blogger.com,1999:blog-19287583.post-39038045542217410472009-01-29T09:16:00.000+11:002009-01-29T09:16:00.000+11:00JP,Reread my post more carefully.The problem occur...JP,<BR/><BR/>Reread my post more carefully.<BR/><BR/>The problem occurs when the file has a "workbook protection" password (and no "file open" password).<BR/><BR/>Try that with an xls and an xlsx and you'll see that the xlsx fails with 1004.<BR/><BR/>You might say "well, don't include the password argument" but the reason I have to do that is in case the user has saved the file with one. If I don't include that argument, Excel will halt waiting for a password to be entered into a dialog box (and this runs unattended, remember). With the password argument supplied, I get a 1004 error and can put the file aside to be dealt with later. I'd rather not have this happen for every xlsx file however.<BR/><BR/>Cheers,<BR/>WazzaWazzahttps://www.blogger.com/profile/03487855618160562635noreply@blogger.com