| How to Autmatically send Mail in Mailboxes | |
Posted: Thu Apr 12, 2007 12:02 pm |
Points: 0 |
|
Doranj00 |
n00b |
|
|
Joined: 12 Apr 2007 |
Posts: 5 |
|
|
|
|
|
|
|
|
Hello,
I am still rather new to GM. we have a legacy system (5.7), so we have the issue where sending large number of html emails fails.
Now, I created a stored procedure that search the mailbox table for mail where folder = 'X-GM-OUTBOX', and I have a sql agent send an email notification to me.
Ok, fine and dandy, BUT I still need to log in as everyone and click the OUTBOX and select send all. This is KILLING me.
Is there another process or api I can use to crawl the outboxes of certain users and send email (These users are all bots, not real users, used to generate emails only).
Thanks in advance hannah_wc@yahoo.com |
|
|
|
|
| | |
Posted: Thu Apr 12, 2007 3:41 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
if the users are set to automatically retrieve mail then you can set the option to automatically SEND mail queued in the outbox when auto-retrieving. In GM 6.7 it's under Edit|Preferences|Internet||More options|Retrieval tab|Send queued messages.
There's an INI setting for it, but I'm not 100% sure what it is. trial and error should reveal it, though.
Also worth noting is this:
http://support.frontrange.com/support/goldmine/533_InternetEMailforMultiplerUsers.htm |
|
|
|
|
| thanks for the Info | |
Posted: Fri Apr 13, 2007 12:38 pm |
Points: 0 |
|
Doranj00 |
n00b |
|
|
Joined: 12 Apr 2007 |
Posts: 5 |
|
|
|
|
|
|
|
|
Thanks Doug. I like the send queued mail option. This big issue is when the mail fails, it puts up a msg box which halts our macros.
Is there a stored proc that I can fire to send a speicifc piece of mail. I wrote a proc that slooks at each outbox so I have all the valus required.
This way, no error will pop up on the screen and kill my macros?
Thanks!
Soooo hard working with such an old system. |
|
|
|
|
Posted: Fri Apr 13, 2007 1:13 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
maybe it's time to write a little app akin to 'click yes' for outlook? Click OK for pop3/smtp error dialogs from GoldMine? |
|
|
|
|
| Auto retrieval | |
Posted: Mon Apr 16, 2007 5:39 am |
Points: 0 |
|
Doranj00 |
n00b |
|
|
Joined: 12 Apr 2007 |
Posts: 5 |
|
|
|
|
|
|
|
|
Hi Doug,
Yeah right. Not sure how though. But I checked the user settings today and autoretrieval is set OFF. As I mentioned, we use a screen macro that signs in as these users so that have alot of things turned off. Our cusotomization are in the form of stored procs so I have gotten rather good at manipulating the db directly with sql.
I have another way to *send* these messages. I have a send email table (another customization) which I can copy the message to be sent and it will be sent.
If I set the flags to (believe its 33 for sent) and update the folder, do you think that will mimic the mail having been sent naturally?
Also, do you know the folder value for mail that was successfully sent?
Thanks for all your advice. |
|
|
|
|
| I think I have it | |
Posted: Mon Apr 16, 2007 6:07 am |
Points: 0 |
|
Doranj00 |
n00b |
|
|
Joined: 12 Apr 2007 |
Posts: 5 |
|
|
|
|
|
|
|
|
Ok,
Looking through the db, I think I can file the message as sent by updating the following
UPDATE mailbox
set flags = 38,
folder = 'Sent',
folder 2 = <the folder where the sent mail should be stored> ie 'April 2007'
WHERE RECID = <recid of message to be sent>
Then I will copy the original messge into my send email table and not do the logging there.
Ok, going to test this on my test system.
Thanks for all the advice. |
|
|
|
|
Posted: Mon Apr 16, 2007 7:42 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
nice sleuthing. I don't have those flag values cataloged, myself, sorry! |
|
|
|
|
Posted: Mon Apr 16, 2007 7:53 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
From The Hacker's Guide:
* The flags field, although character based, contains the the converted binary number which relates to the following states:
Bit On Off
1 Read Not Read
2 In History Not in History
3 Outbound Inbound
4 Attachments No Attachments |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
Posted: Mon Apr 16, 2007 9:13 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
given that list, what's 38 mean, then? |
|
|
|
|
Posted: Mon Apr 16, 2007 9:34 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
| Flags bit | |
Posted: Tue Apr 17, 2007 4:56 am |
Points: 0 |
|
Doranj00 |
n00b |
|
|
Joined: 12 Apr 2007 |
Posts: 5 |
|
|
|
|
|
|
|
|
Yeah, I know that - but as good as I am with manipulating the db, I dont know how to covert the bit from char.
I got the values from looking through the mailbox table where folder = 'Sent'
All the values there are 38.
Maybe I need to do some research on bit manipulation and do it right <blush>.
The only thing I need to do now is figure out how to parse the mailref field. This field contains all the mail data including from, to etc, but I am only able to parse the sent to portion. Must have crlf and all. Will work on that and bit manipluation today.
Hey, glad to see this portion of the forum picked up. When I first posted, there were no posts of any type! Nice to know we are not the ONLY company using legacy-ware!
Also, thanks for all the advice and help. These type of forums really allow you to get down and dirty with a product that is new to you!
Thanks |
|
|
|
|
ContactReview Forum Index » GoldMine Legacy
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|