Eric,
A few thoughts about your problem. I understand your motivation for
wanting the information brought to your attention without looking for
it. On what machine will this application be running and what event
will trigger it to look for values that meet your criteria? You
can't just have an Excel file sitting closed on your network that
will fire off e-mails. The file will need to be open on someone's
machine and some sort of event will have to occur to fire the macro.
If I were attempting to do what you are doing I would look at using
Access instead of Excel. I'm not saying its not possible in Excel,
but I think Access would be better suited. I've purchased a handy
tool called Total Visual Agent that I use to run Access Macros at
scheduled times. It is running on our IT Asst's PC overnight doing
all kinds of things automatically. There is a macro command in
Access that will Send an Object, like a report, to people as an e-
mail. I haven't tried to program the recipients names in there say
they change dynamically, but I don't think that would be a problem.
I'm not e-mailing anything, but I have an Access program that uses a
query to select records meeting a criteria, then runs through a loop
and performs a macro for each record. I you had the contact info in
your table with the Job and Warranty Date, I think it would be pretty
easy to do.
Let me know if you need some help with the code or setting up the
loop.
Brian Stenglein
Clow Stamping Company
A few thoughts about your problem. I understand your motivation for
wanting the information brought to your attention without looking for
it. On what machine will this application be running and what event
will trigger it to look for values that meet your criteria? You
can't just have an Excel file sitting closed on your network that
will fire off e-mails. The file will need to be open on someone's
machine and some sort of event will have to occur to fire the macro.
If I were attempting to do what you are doing I would look at using
Access instead of Excel. I'm not saying its not possible in Excel,
but I think Access would be better suited. I've purchased a handy
tool called Total Visual Agent that I use to run Access Macros at
scheduled times. It is running on our IT Asst's PC overnight doing
all kinds of things automatically. There is a macro command in
Access that will Send an Object, like a report, to people as an e-
mail. I haven't tried to program the recipients names in there say
they change dynamically, but I don't think that would be a problem.
I'm not e-mailing anything, but I have an Access program that uses a
query to select records meeting a criteria, then runs through a loop
and performs a macro for each record. I you had the contact info in
your table with the Job and Warranty Date, I think it would be pretty
easy to do.
Let me know if you need some help with the code or setting up the
loop.
Brian Stenglein
Clow Stamping Company
--- In vantage@yahoogroups.com, "Tyira Eric" <eric.tyira@t...> wrote:
> We keep track of our warranty expiration dates in excel. I guess
this spreadsheet would require a column for "email sent". I would
then activate a macro that would send an email notification to
certain people if the job warranty has expired and then mark the
aforementioned column as "yes" so a second email does not get sent
next time.
>
> What I am really looking for are ways to automate some processes so
we have less manual "trolling". I don't want to go fishing for
information - I want the information brought to my attention at the
right time. I want to disseminate information to the right people at
the right time and I want to leverage technology to do it. This
includes the information stuffed in emails, spreadsheets and
documents that resides in umpteen thousand directories on our server.
>
> Am I looking for PDM (Product Document Management) software?
> Am I looking for to develop an intranet site that houses all our
little manufacturing secrets, requirements, work instructions, design
criteria, etc. so they can be shared with those who need it when they
need it?
> Can some of this be done in Vantage (I know, I'm going off here,
but I need to vent!)?
>
> If anyone knows what I'am talking about and has done anything like
this, or feels the same way, please chime in.
>
> Thanks.
>
> Eric L. Tyira
> Tamglass Tempering Systems
>
> P: (856) 786-1200
> F: (856) 786-7606
>
> eric.tyira@t...
>
> -----Original Message-----
> From: HPN Charles Paluska [mailto:cpaluska@h...]
> Sent: Monday, September 27, 2004 1:49 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] OT - Excel generate email based on cell value
>
> Do you want the email to occur automatically on a scheduled basis
(i.e. once
> a day, once a week) ?
> Also, do you want human involvement with the process - the
spreadsheet must
> be open and activated by someone then and only then will the
notification be
> transmitted??
>
> Trying help,
>
> Charles
>
>
> ----- Original Message -----
> From: "Tyira Eric" <eric.tyira@t...>
> To: "Vantage User Group (E-mail)" <vantage@yahoogroups.com>
> Sent: Monday, September 27, 2004 11:18 AM
> Subject: [Vantage] OT - Excel generate email based on cell value
>
>
> > Hey all.
> >
> > Is there a way to have excel generate an email to be sent when a
cell
> value reaches a set value?
> >
> > Example:
> > There is a list of jobs in excel. The warranty date is set via
the sales
> date (sales date plus 12 months). If the warranty has expired, I
want an
> alert sent to certain people containing the job/customer info and
to have
> them do certain things.
> >
> > Do I need to write code? AutoIT? Etc.
> >
> > I know what I want. I know it can be done. I just don't know
where to
> start.
> >
> > Thanks.
> >
> > Eric L. Tyira
> > Tamglass Tempering Systems
> >
> > P: (856) 786-1200
> > F: (856) 786-7606
> >
> > eric.tyira@t...
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
<http://us.ard.yahoo.com/SIG=1296me1mi/M=295196.4901138.6071305.300117
6/D=groups/S=1705007183:HM/EXP=1096393724/A=2128215/R=0/SIG=10se96mf6/
*http://companion.yahoo.com> click here
>
> <http://us.adserver.yahoo.com/l?
M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=4102320
76>
>
> _____
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms
of <http://docs.yahoo.com/info/terms/> Service.
>
>
> [Non-text portions of this message have been removed]