johan May 15 2009, 06:37 AM SouthrendThanks for the info on the Contact Information. Page 1 of 2 1 2 Next > Advertisement dgamboa9999 Thread Starter Joined: Feb 4, 2014 Messages: 12 Good afternoon, I am struggling with the above error when trying to write My problem is that I need a code sample of how to get Outlook 2010 to accept the _app.date and _app.time values, and other variables needed for scheduling an appointment, and Does lblType(i, 0) work? Check This Out
Click on Add to Outlook!"ElseEnd IfExit_cmdCheckEmailAddress_Click:Exit SubErr_cmdCheckEmailAddress_Click:If Err.Number = 429 ThenSet appOutlook = CreateObject("Outlook.Application")Resume NextElseMsgBox "Error No: " & Err.Number & "; Description: " & Err.DescriptionResume Exit_cmdCheckEmailAddress_ClickEnd IfEnd Sub--------------------------------I want to Join UsClose Full Version: Mobile, Business, Home & Business Fax Numbers to Outlook 2007 UtterAccess Forums > Microsoft® Access > Access Automation johan May 15 2009, 03:28 AM The following peace Register To Reply 07-09-2013,05:57 PM #4 clapforthewolfman View Profile View Forum Posts Registered User Join Date 06-28-2013 Location London, Ontario MS-Off Ver Excel 2010 Posts 69 Re: Send email from Excel Register To Reply 07-10-2013,04:09 PM #11 clapforthewolfman View Profile View Forum Posts Registered User Join Date 06-28-2013 Location London, Ontario MS-Off Ver Excel 2010 Posts 69 Re: Send email from Excel
So, you need to process the array. which means that you can then use objMailItem.To = cboAssociate.Column(2) I don't know if that will fix all the problems as I no longer use Outlook, I use Windows Live Mail. We have two different business entities and the above code works for one business entity, but not the other. Outlook cannot translate your string." Any ideas about what's going wrong and what it could be that Outlook doesn't like would be great. 0 Comment Question by:LJKMartin Facebook Twitter LinkedIn Email
The fact that Outlook 2007 allowed to pass a string when using late binding and it was nice enough to convert it to DateTime was really a fluke. Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. I will try your suggestion - thanks "Sue Mosher [MVP-Outlook]" wrote: > Don't you need single quotation marks around the string value in the SELECT statement? How is the correct air speed for fuel combustion obtained at the inlet of the combustor?
That should contain the data from the recordset, but I don't see that you're doing anything with it. > >> >> >> > >> >> >> "Eric J"
Exchange Outlook Social Networking Exclaimer Office 365 Top 5 email disclaimer tips Article by: Exclaimer Get an idea of what you should include in an email disclaimer with these Top 5 If the combobox has more than one column you have to do something like cbo#.columns(0).value As the code was working, it's got to be something simple. –Jimmy Smith Feb 4 '14 dgamboa9999, Feb 4, 2014 #1 Sponsor Rollin_Again Joined: Sep 4, 2003 Messages: 4,882 As far as I know there is no built in item type called "olMailItem1" which being used Actually, they are not string values per say.
I will try your suggestion - thanks > >> > > >> > "Sue Mosher [MVP-Outlook]" wrote: > >> > > >> >> Don't you need single quotation marks around the his comment is here That should contain the data from the recordset, but I don't see that you're doing anything with it. >> >> >> >> >> >> "Eric J"
What you want is a string, though, right? This site is completely free -- paid for by advertisers and donations. I have since added an "issue date" to the form, but not to the email. this contact form What you want is a string, though, right?
So, you need to process the array. Get 1:1 Help Now Advertise Here Enjoyed your answer? Attached Files: Associate Tracker (ARCMasterVersion).7z File size: 170.7 KB Views: 42 dgamboa9999, Feb 5, 2014 #10 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,087 Can you remove the database and
It's driving me crazy, you guys are my only hope! It's been working fine for years but now we have a problem. Only one would do. Does lblType(i, 0) work?
I'll have a look at the article, but in the meantime make sure the users are using plain text. 0 Featured Post How to run any project with ease Promoted by So I am trying to see > > how to get this value into a variable that I can pass to the message body. > > Thanks for replying > > And this: Please Login or Register to view this content. navigate here Register To Reply 07-10-2013,02:37 PM #9 Solus Rankin View Profile View Forum Posts Forum Expert Join Date 05-24-2013 Location Hollywood, CA MS-Off Ver Win7 Office 2010 VS Express 2012 Posts 2,655
I combine the two in an index so the values are in chronilogical order when displayed. Outlook cannot > translate your string > ------------------------------------------------------------- > I've loooked on the Internet on this, but there almost anything > on this, and I can't figure the answer to this Thanks a lot in advance. I will give it a try but I was thinking it might be with how I > >> > create the recordset and get the value out of the recordset but
Also, will .Text keep the formatting I had on the body cells? –Scott Sep 5 '14 at 22:50 Please show your latest code. –Dmitry Streblechenko Sep 6 '14 at Advertisements do not imply our endorsement of that product or service. Repost it with them removed. I'm using a sample code I've found on Deborah Pate's page.