Help with basic workflow........please
I am looking at creating a basic workflow (initially anyway).
What I want to be able to do is if any details on the contact records
changes to then a email is automatically sent to the record owner telling
them that info has changed. It would be good to include in the email subject
the account name and the contacts name?
Is there anyone that could get me started maybe?
Thanks in advance
What you need is not a Workflow but rather a Callout.
A Workflow can handle one of these 4 triggers: Create, Manual, Reassign and
Status Change. None of these are triggere...Help with RecordSetClone
this is my first attempt at using recordsetclone to look at the same field
on a continuous form and update the field. I have looked at other examples
on this forum and put together the below code but I keep getting an "invalid
argument 3001 error" when it reaches the first .FindNext.
.Bookmark = Me!subfrmPersons.Form.Bookmark
MsgBox Me!subfrmPersons.Form![DOB] 'for testing only
If Not IsNull(Me!subfrmPersons.Form![DOB]) Then Me!subfrmPersons.Form!
[Age]...Help! COUNTIF and SUMPRODUCT are eating my brain!
This *should* be easy, I guess, but I keep getting errors where I canno
see a problem with my formula (Tho' admittedly I'm by no means an Exce
expert). Here's my task:
I have column G labeled "Tasks" and the cell values are either "Open"
"Closed", "Cancelled", or blank. Then I have column L labeled "Name
and the cell values are, of course, names. I'm simply trying to come u
with a formula that will tally the tasks that are "Open" and of those
how many are assigned to "Smith".
After fruitless attempts using COUN...how do i make an attachment?
I dont know how to make my doc an attachment.
You don't have to do anything with the document (apart from save it) for it
to be an attachment. Simply open your e-mail application and choose the
option to attach a file. Select the document and complete the e-mail
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<>...Office Professional 2007 trial..need help
I purchased a 180 day trial version with disc in Jan 2010, installed into
computer and the motherboard died. I purchased new computer with Windows 7
(previous computer was Vista) and tried installing and it won't work. I
uninstalled everything Office and tried downloading the 60 day trial, still
won't work as I get the activation expiration date of Dec. 31, 2002.
Any ideas as now when I try to download from the website, it tells me I have
downloaded my alotted number of times - still have no working programs and
need them for a class - must be microsoft 2007 pro.
Any help...my merge and centre icon is just a shadow, help?
i am using excel a lot at the moment but am primarily self taught. I have
managed to lock down my merge and centre button so all I can see is a shadow
of the light grey imprint.
How can I release the icon? noting I have tried to customize and drag the
merge back again but as soon as I close the box I again lose the icon?
Urgently needed to finish spreadsheets this weekend!!!
Worksheet is protected?
Workbook is in Shared mdoe?
Either of these will disable merge and center.
Since you are learning I would suggest you quickly unlearn the use of merge
Causes many problems whe...Can you help a NEWBIE please
I need a little help, as I'm trying to help my father with a
spreadsheet but have got stuck. I have 2 Columns, TransactionID and
What I want to be able to do it to create/compute a 3rd column based on
the other 2. Now this is where I am getting stuck. The Rule is that for
a TransactionCode of T or H this needs to be changed to either a "AA"
or BB depending on what the other value is for the same Transaction ID.
ie this would be the final output.
5 T AA
5 AA AA
6 H BB
6 BB BB
7 AA AA
7 T AA
8 T BB
8 BB BB
The sort of ...exchangeserver help
i need a guidence in exchange server
"shekhar" <email@example.com> wrote in message
>i need a guidence in exchange server
Best thing to do is try install it and try connect some outlook client and
send emails to each other. I have found with most software once you install
and know what your purpose you know what to read and what questions to ask.
This newsgroup is very good for asking questions.
"shekha...help with distribution formula!
i need to make a distribution table. i know that i use the -normdist-
function, i just can't figure out what to put in each argument.
my data is 10 questions, and each question has 5 answers to choose from
(multiple choice). Assuming that im making complete random guesses, i
need to find the probability of getting 1 question correct, 2
questions, 3, 4, and so on until i get the prob. of getting all 10
correct. what would i plug into each argument?
standard Dev -
i'm not specifically asking for the answers, but more for help on
figuring out which goes into...Waitable Timer Question Please help!
I am trying to use the waitable timer in a MFC project and using MsgWaitForMultipleObjectsEx() to wai
on the timer handle. But my timer callback doesnot get executed. Below is the source code with al
the error checking removed. Please help me to fix this problem
int wLoopCount= 0
int breakLoop = 0
int retVal = 0
// Create waitable time
hTimer = CreateWaitableTimer(NULL, TRUE, "WaitableTimer")
// start the timer 5 sec from now and tick every 2 se
liDueTime.QuadPart = -5000...Need help with OUTPUT parameters
I am trying to execute two child stored procedures from a parent one. The
first stored procedure inserts a new company into Companies table and returns
its CompanyID, the second stored procedure inserts an address into Addresses
table and returns its AddressID and the third one assigns the address to the
Everything works fine but when I run the parent stored procedure, I only
want to return the CompanyID back to my application. However, the code below
returns both CompanyID and AddressID.
I'm using OUTPUT clause so that I can grab CompanyID and AddressID r...Line-Column 2 axes Help
I can't seem to set up a line/column graph and format it correctly. I have
over 10 series of elevation data and corresponding dates from one worksheet,
and precipitation data and corresponding dates from another worksheet.
I have the the elevation series plotted to the 2nd x axis (date) and the
precipitation series plotted to the 1st x asis (date). Precip data on the
left y axis and Elevation data on the right y axis.
Ideally, what I want is line graphs for the elevation data and bar chart for
the precip data. I can either get ALL the data to be line graph data, or one
of my ele...Can't attach files now
I have been using Windows Mail (The 2006 desktop version) for quite sometime
now. I have always been able to attach files but today when I tried to send
my resume like I always do, it wouldn't attach. It says some files could not
be attached. What is the problem with that?
"asiankelsey" <firstname.lastname@example.org> wrote in message
> I have been using Windows Mail (The 2006 desktop version) for quite
> now. I have always been able to attach files ...SMTPreg.vbs eventsink blokking vital system mail replication
I have a problem with an eventsink, I have three exchange 2003 servers,
each sitting in its own routing group called inner, outer and middel
RG, mail sendt from the inner server must be logged and blocked if not
sendt from a valid email klient, so what is done is that all mail sendt
from the inner server must travel through the middle server and the
eventsink is instaleld on the middle server. this works just fine, mail
gets blocked. But since what triggers the eventsink is absence of an
outlook addon, all system mail sendt between the three servers gets
blocked. I need to let system mail b...Query Expression help
What is the correct expression to get average handle time per return, rather
than per batch (returns are logged in batches that vary in quantity).
Currently using this espression to get AHT per batch- Handle Time: [Sign In
Time]-[Sign Out Time]
I would like to divide this sum by [Processed], which is already an
expression Processed: [Filed]+[Sent to Accounting]+[Pended] to ger AHT per
I tried- Handle Time: sum([Sign In Time]-[Sign Out Time])/[Processed], but
that doesn't work.
Perhaps the following, although I suspect that will not give you the results
S...excel help 04-09-10
I have a table (range a5:s33) that is changing constantly and its being
updated. I need cell I1 and I2 to give me the date (I1) and time (I2) when
any of the cells within the range are modified....any help?...thanks
Try the following Sheets Event-Macro:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, [A5:S33]) Is Nothing Then
[I1] = Date
[I2] = Time
> I have a table (ran...Security on Attachments in notes
As Notes can be role-secured on write/delete, etc. Can this be done solely on
the attachments in the notes?
Wanted result; a note on itself is editable after save, but an attachment
can not be deleted.
I don't think this is possible, but maybe someone?
...Excel Help for $ ! :)
I run www.AndyFutureRDH.com and have created a workbook with 13 pages
(12 monthly and 1 yearly total page)...
I have perfected as much as I can with my limited knowledge but would
like to hire someone for a one time deal to take it and make it kick
butt! Before any work is to be done I will email you the file I
created and you will offer me what you can do to it to make it better
and for how much.
Please email me with questions or inquiries:
with the subject "ANDY EXCEL HELP"
Andy Codding RDH
Message posted from http://www.ExcelForum.com/
Andy,...Help eith macro and command function
I need help with the procedure required to complete the
following task. I have a spreadsheet that if data is
enetered into cell range J6:N6, the user is prompted to
eneter a date, which will reside in cell Q6.
Any help will be appreciated.
I;ve attemped to use a form, with a command button and a
tex dox, however with not much success, any help would be
You could use the Wroksheet_Change event to prompt for the date. For
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row >= 6 Then
If Target.Column >= 10 And T...help with ranges
I need a to know a formula for a range that verify's another field has
certain varaible or # the goes to another field in the same record an
copies the next 4 cells down and then pastes the the copie
information in the next column but same record. transposes the dat
for the 4 cells, so all data on the same record
Message posted from http://www.ExcelForum.com
It's a bit hard to figure out. Could you send a sample
sheet of "Was" and "Now" to email@example.com and
I will write a macro or userform utility for you. You can
verify my ability at my use...Help with Ribbons! AAARGH!
I found this example on Ron de Bruin's site on how to create a custom
I followed it to the letter but the Ribbon does not appear at all when
I open the file.
What could I be doing wrong? Are there some settings that I need to
check for this to work?
Why Microsoft? Why would you do this?!?!?!?!
Thanks in advance!
It is difficult to answer, we don't know what you did, but did you enable
macros in the new file?
"JJ" <firstname.lastname@example.org> wrote in message
news:b7f14808-961f-4...HELP:signature advance edit
how do I change the signature advance edtitor application?
Now , My outlook 2003 signature advance editor is notepad,
I just want to switch it to Word.
...Urgent Help Needed!!
I'm making a leagye table and I need to link a line graph up to the
results of a team chosen by a combo box, and then read the positions
that that team has been in during the season so that it shows the
increse/decrease in the teams performace.
Attachment filename: image2.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=404739
Message posted from http://www.ExcelForum.com/
any ideas are welcome, i don't mind if i have 2 change anything to get
it to work, i just need to do this a quite urgently?
If needed to i will do it a...help! how to remove reference to MS Exchange account?
I do NOT have MS Exchange account, only Internet email.
By mistiake I specified Exchange in the installation, but
with no valid account, Outlook will only allow me to open
I have removed and reinstalled Outlook 2000 twice, and
there appears no opportunity to remove the reference to MS
rockypierre <email@example.com> wrote:
> I do NOT have MS Exchange account, only Internet email.
> By mistiake I specified Exchange in the installation, but
> with no valid account, Outlook will only allow me to open
> local files.
> I have re...Urgent Help needed :Transferring MA questionnaire
This has been compiled on an Access 2000 home pc and we
wnat to transfer it to my laptop with XP Access 2003.
Unfortunately it ended up with an 'mde' tag in the
process. It is only the database its self and contains no
queries or reports.
A further problem is that in trying to build the database
again on my laptop, in Access 2003, it will not allow it
to be saved in 'save as' or in 'save' : it keeps coming up
with "indexes must have names". What does this mean?
Please HELP !! I must be able to write up my answers
during the next week!