Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine Legacy » How to Autmatically send Mail in Mailboxes
Post new topic  Reply to topic View previous topic :: View next topic 
How to Autmatically send Mail in Mailboxes
PostPosted: Thu Apr 12, 2007 12:02 pm Points: 0 Reply with quote
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
View user's profile Send private message Send e-mail

PostPosted: Thu Apr 12, 2007 3:41 pm Points: 0 Reply with quote
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

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

thanks for the Info
PostPosted: Fri Apr 13, 2007 12:38 pm Points: 0 Reply with quote
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.
View user's profile Send private message Send e-mail

PostPosted: Fri Apr 13, 2007 1:13 pm Points: 0 Reply with quote
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? Smile

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Auto retrieval
PostPosted: Mon Apr 16, 2007 5:39 am Points: 0 Reply with quote
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.
View user's profile Send private message Send e-mail

I think I have it
PostPosted: Mon Apr 16, 2007 6:07 am Points: 0 Reply with quote
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.
View user's profile Send private message Send e-mail

PostPosted: Mon Apr 16, 2007 7:42 am Points: 0 Reply with quote
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!

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon Apr 16, 2007 7:53 am Points: 0 Reply with quote
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
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon Apr 16, 2007 9:13 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




given that list, what's 38 mean, then?

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon Apr 16, 2007 9:34 am Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




I have no clue.

_________________
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
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Flags bit
PostPosted: Tue Apr 17, 2007 4:56 am Points: 0 Reply with quote
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
View user's profile Send private message Send e-mail

How to Autmatically send Mail in Mailboxes
  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  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin