Thanks Sue,
I took a look at your book at Borders Books... Wow there is a lot of
stuff in there. I'm not a programmer so this is all seems way over my
head... but I desperately need a solution.
I'm in deep SH** co workers have figured out they can pass off their
issues on to my department... It comes down to There is no records or
accountability for me to back my counter claims of requests and
submissions that were filed. I’m simply the fall guy. So I need to
Cover my A** and document everything. Having a policy to request ads
by filling out a form will eliminate any discrepancy. But will also
allow me to track all of my current ad insertions if senior management
wants to see what we have done or what we will be doing.
I’m looking to build a form within outlook for my co workers to request
advertising materials from me. Once I get that request, I want the
control to post it in a tasks timeline view by simply booking it with
the form information provided to me via the request. AKA (ad due
date,Ad reservation date, Ad running start date and ad running end date
and where it's to run.)
I would like to post it so everybody can see their request and all the
information I create pertaining to it via a restricted task timeline
view. They will be able to see their ad, where it is running, how
long and cost. If there is an error it’s their error because it
exactly what they submitted.
I also would like a response notice for that ad going back to them with
the specs, times, cost and other info pertaining to it.
For myself I would use the form to create records of what ads I am
running, where, how long and cost with out receiving a request. There
are times I just push ads with out having them requested. It would be
great to generate a Notice with the specs going out to my stores in
that instance. I figure the original request form would work with minor
adjustments. I've begun building the form for the request, it has the
elements I am looking for but the actual functionality and coding is
not working. Picking apart the templates has allowed me to get where
I’m at now.
A little background…I’m using the business contact add-on for outlook.
I set up the branch stores I service as the Accounts and the Managers of
those stores act as the Primary contacts linked to that accounts. In
the request for Advertisement form I would like the contact information
fields to self populate with information from the business contacts
depending on which branch is requesting the information. A date/time
picker with the ability to add a couple of days to it would be handy…
It would force anybody who requests an ad to get it to me on time.
Rather than giving me the request the same day it is due to the
printer.
Where do I start?
Sorry this is a bunch of stuff… after reading several posts I noticed
that most here post their problem code and you recommend how to fix it.
I don’t have any code only Ideas of how my system would look and
function.
Any help would be HUGE… my thanks everybody for reading this.
Miea
--
bitterdine
Posted from -
http://www.officehelp.in