Hi Blake,
No, I actually never got this issue resolved as in working exactly the way I wanted it. Instead I ended up writing a little .Net executable that called some Outlook API:s to just open the emails for viewing, and then my colleague had to click "send" individually for each email. This took a while - some half hour at most, but compared to the full day it could take to manually generate the emails, add attachments...
BlackMustard
Last Activity: Jan 7 '09, 05:22 PM
Joined: Aug 27 '07
Location:
-
i found the problem myself:
32999 is a number too large to store in an integer variable - but even though i changed the explicit conversion to double, the variable was still declared as an integer. therefore, an implicit conversion to integer took place, which caused the overflow.Leave a comment:
-
yes, you need to import Microsoft.Visua lBasic - it's on the msdn page:
"Requiremen ts
- Namespace: Microsoft.Visua lBasic
- Module: Information
- Assembly: Visual Basic Runtime Library (in Microsoft.Visua lBasic.dll)"
if you add [code=vb]Imports Microsoft.Visua lBasic[/code] at the top, it will work....Leave a comment:
-
according to msdn, IsNumeric should work in .Net 3.5 (VB 2008) as well: http://msdn2.microsoft .com/en-us/library/6cd3f6w1.aspx...Leave a comment:
-
strange "overload" error at only 32999
hi all,
i am trying to convert the string "32999" to a number, in order to compare it to other numbers and tell which one is the largest one, or if they're equal.
i keep getting an overflow error. this is for a macro organizing numbered folders, so i started out with lower numbers using [code=vb]CInt(myNumberSt ring)[/code] which worked fine up to this point.
the odd thing is that i get overload using... -
hi again,
i found this thread: http://www.thescripts. com/forum/thread764272.ht ml
in there there's source code for a "killer" class, which starts a separate thread to kill dialog boxes. it works excellent for the dialog that asks for permission to access outlook functions, but i can't get it to kill the little dialog for the actual sending operation - i assume this is because the dialog box has a five second...Leave a comment:
-
automate email sending via outlook
i have coded a little windows application in vb.net, which looks up a lot of info from an excel sheet, defines and fills new outlook.mailite m:s with information and attempts to send them. but for each mail that is to be sent, i get a message from outlook saying "A program is trying to send emails on your behalf. Do you want to allow this? If this is unexpected it might be a virus and you should choose No." I have to wait a couple of seconds... -
thanks for your reply! unfortunately it didn't get me all the way... i'm extremely new to java, and so far i've done everything in some sort of "design view" in netbeans 6. i took a look at the page and understood some of it, but when i tried to insert the [code=java]protected void keyPressed(int keyCode){}[/code] method i just got errors everywhere...
do you know any way to insert this method in the right place through some...Leave a comment:
-
react to 1-9 button click in java mobile app
hi all,
i'm building my first java application for symbian os, and need to write custom logic to react to buttons 1-9 being pressed. how do i do that? where do i add the routines etc?
i'm using netbeans 6.0 with the mobility pack, so if there's a visual "shortcut" i'll gladly use it ;)
thanks!
-tomas -
print word file to pdf from outlook macro
hi all,
i currently have a macro in outlook to alter a word document, save as new file and attach. is there any way to, in this automated process, print the word output to pdf and attach the pdf instead?
-tomas -
you must have magic fingers - it works! thanks!
i really do feel happy i started .net - passing parameters to a routine without parenthesis feels just odd... and a compiler getting a "type mismatch" error when you try this way is even worse. do you know if there's any way to write macros in vb.net instead?
anyway, thanks for helping me out!...Leave a comment:
-
insert column in union select statement
hi all,
i am currently using the following union select statement to select records from two of my tables to a gridview in asp.net:
now i'd like to add two things to this statement:...Code:SELECT ConcertName AS Name, ConcertDate AS Date, ConcertTime AS Time, ConcertPlace AS Place FROM Concerts UNION SELECT EventName AS Name, EventDate AS Date, EventTime AS Time, EventPlace AS Place FROM Events ORDER BY Date, Time
-
and by the way (excuse the double posting, i didn't find the edit button) i don't think outlook has updated recently. maybe it has, but in that case it was just a very minor update, since i didn't notice. corporate networks...Leave a comment:
-
take a look at regular expressions - checking for valid email addresses is one of the most common usage areas for this.
you can find more info at regularexpressi ons.info, regexlib.com or by googling for "regular expressions"....Leave a comment:
-
line 10:
[code=vb]myCurrentItem.M ove (myTargetFolder )[/code]...Leave a comment:
-
as the others have stated, you use try...catch to catch errors.
[CODE=vb]Try
' any code that might generate an error here, for example connecting to a database
Catch ex As Exception
' react to the error here. in this example, I want to throw the error
Throw ex
End Try[/CODE]
if you use the above code, it differs little from just running the code without try...catch. but if you change the code...Leave a comment:
-
[tilt tilt...]
i really need help with this - i use these macros all the time, and when nothing's working everything takes twice as much time as it does if they work... so please - help! ;)Leave a comment:
-
moving emails in outlook - type mismatch error
hi all,
i have used the following macro to move unimportant (i.e. non-work related) mail in my outlook inbox into a folder in personal folders. it has worked for a long time, but suddenly it gives a "type mismatch" error when trying to move the mailitem.
[code=vb]Sub UnimportantMail ()
Dim myTargetFolder As MAPIFolder
Dim myCurrentItem As Outlook.MailIte m
Set myCurrentItem... -
well, the most efficient equivalent to a digital certificate would be to get your security people to insert a check routine into the routine that deletes macros. to make this possible without making your secret code available, maybe you could compile a dll with the check routine in it (for example, a function that checks for your special line in a file, with the file as input and true/false as output), and then they could just call the function with...Leave a comment:
-
i really must admit that i don't have any idea how it would work either... but i might be able to help brainstorming anyway =) how does the removal tool work that you're trying to bypass?...Leave a comment:
No activity results to display
Leave a comment: