Field for next working day in outlook template file?
I was hoping to be able to create a mail template with an automatically updating field for the next working day.
As of now I have found { TIME @ "d-M-yyyy" }
, which displays todays time (it updates if the template is opened on another day). But I have no clue on how to show tomorrows date, not to mention the next working day. Functions such as EXCEL's WORKDAY
do not seem to work.
Can I create an automatically updating field in an outlook template that will always show the next (working) day?
outlook
add a comment |
I was hoping to be able to create a mail template with an automatically updating field for the next working day.
As of now I have found { TIME @ "d-M-yyyy" }
, which displays todays time (it updates if the template is opened on another day). But I have no clue on how to show tomorrows date, not to mention the next working day. Functions such as EXCEL's WORKDAY
do not seem to work.
Can I create an automatically updating field in an outlook template that will always show the next (working) day?
outlook
I think thoses can be help you : stackoverflow.com/q/19711400/9940803
– pascal sanchez
Jan 5 at 21:22
1
Thanks @pascalsanchez I was hoping for a method without macro's, but I will look into it.
– Neograph734
Jan 7 at 10:22
i'm going to find way without any macro's .
– pascal sanchez
Jan 7 at 10:26
add a comment |
I was hoping to be able to create a mail template with an automatically updating field for the next working day.
As of now I have found { TIME @ "d-M-yyyy" }
, which displays todays time (it updates if the template is opened on another day). But I have no clue on how to show tomorrows date, not to mention the next working day. Functions such as EXCEL's WORKDAY
do not seem to work.
Can I create an automatically updating field in an outlook template that will always show the next (working) day?
outlook
I was hoping to be able to create a mail template with an automatically updating field for the next working day.
As of now I have found { TIME @ "d-M-yyyy" }
, which displays todays time (it updates if the template is opened on another day). But I have no clue on how to show tomorrows date, not to mention the next working day. Functions such as EXCEL's WORKDAY
do not seem to work.
Can I create an automatically updating field in an outlook template that will always show the next (working) day?
outlook
outlook
asked Jan 2 at 10:25
Neograph734Neograph734
1,36211233
1,36211233
I think thoses can be help you : stackoverflow.com/q/19711400/9940803
– pascal sanchez
Jan 5 at 21:22
1
Thanks @pascalsanchez I was hoping for a method without macro's, but I will look into it.
– Neograph734
Jan 7 at 10:22
i'm going to find way without any macro's .
– pascal sanchez
Jan 7 at 10:26
add a comment |
I think thoses can be help you : stackoverflow.com/q/19711400/9940803
– pascal sanchez
Jan 5 at 21:22
1
Thanks @pascalsanchez I was hoping for a method without macro's, but I will look into it.
– Neograph734
Jan 7 at 10:22
i'm going to find way without any macro's .
– pascal sanchez
Jan 7 at 10:26
I think thoses can be help you : stackoverflow.com/q/19711400/9940803
– pascal sanchez
Jan 5 at 21:22
I think thoses can be help you : stackoverflow.com/q/19711400/9940803
– pascal sanchez
Jan 5 at 21:22
1
1
Thanks @pascalsanchez I was hoping for a method without macro's, but I will look into it.
– Neograph734
Jan 7 at 10:22
Thanks @pascalsanchez I was hoping for a method without macro's, but I will look into it.
– Neograph734
Jan 7 at 10:22
i'm going to find way without any macro's .
– pascal sanchez
Jan 7 at 10:26
i'm going to find way without any macro's .
– pascal sanchez
Jan 7 at 10:26
add a comment |
1 Answer
1
active
oldest
votes
I think i might have a solution for you. I assumed by working days you mean Mo-Fr, ignore holidays and the like.
Because copy and pasting complex field code is a royal pain I can only give you a screenshot. But i have also attached working example in form of a word doc and an outlook template: https://drive.google.com/drive/folders/1EYAR5GzIEw8YatGZ_wGsBXNfxf4BV8HI?usp=sharing
Unfortunately field codes don't seem to have anything to get the day of the week as a number. So in my example I have referenced english day names, you may need to adjust accordingly.
Hope this helps.
Cheers
Screen shot of field code
Whoow thanks, this looks really promising. I'll need to take a better look, but for now many thanks. Furthermore, in terms of Stack overflow policies, the actual answer should be embedded in your post and not be a linked resource (in case the link goes down). Could you edit the post a little so the essential parts of the answer are visible here?
– Neograph734
Jan 12 at 11:24
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004646%2ffield-for-next-working-day-in-outlook-template-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I think i might have a solution for you. I assumed by working days you mean Mo-Fr, ignore holidays and the like.
Because copy and pasting complex field code is a royal pain I can only give you a screenshot. But i have also attached working example in form of a word doc and an outlook template: https://drive.google.com/drive/folders/1EYAR5GzIEw8YatGZ_wGsBXNfxf4BV8HI?usp=sharing
Unfortunately field codes don't seem to have anything to get the day of the week as a number. So in my example I have referenced english day names, you may need to adjust accordingly.
Hope this helps.
Cheers
Screen shot of field code
Whoow thanks, this looks really promising. I'll need to take a better look, but for now many thanks. Furthermore, in terms of Stack overflow policies, the actual answer should be embedded in your post and not be a linked resource (in case the link goes down). Could you edit the post a little so the essential parts of the answer are visible here?
– Neograph734
Jan 12 at 11:24
add a comment |
I think i might have a solution for you. I assumed by working days you mean Mo-Fr, ignore holidays and the like.
Because copy and pasting complex field code is a royal pain I can only give you a screenshot. But i have also attached working example in form of a word doc and an outlook template: https://drive.google.com/drive/folders/1EYAR5GzIEw8YatGZ_wGsBXNfxf4BV8HI?usp=sharing
Unfortunately field codes don't seem to have anything to get the day of the week as a number. So in my example I have referenced english day names, you may need to adjust accordingly.
Hope this helps.
Cheers
Screen shot of field code
Whoow thanks, this looks really promising. I'll need to take a better look, but for now many thanks. Furthermore, in terms of Stack overflow policies, the actual answer should be embedded in your post and not be a linked resource (in case the link goes down). Could you edit the post a little so the essential parts of the answer are visible here?
– Neograph734
Jan 12 at 11:24
add a comment |
I think i might have a solution for you. I assumed by working days you mean Mo-Fr, ignore holidays and the like.
Because copy and pasting complex field code is a royal pain I can only give you a screenshot. But i have also attached working example in form of a word doc and an outlook template: https://drive.google.com/drive/folders/1EYAR5GzIEw8YatGZ_wGsBXNfxf4BV8HI?usp=sharing
Unfortunately field codes don't seem to have anything to get the day of the week as a number. So in my example I have referenced english day names, you may need to adjust accordingly.
Hope this helps.
Cheers
Screen shot of field code
I think i might have a solution for you. I assumed by working days you mean Mo-Fr, ignore holidays and the like.
Because copy and pasting complex field code is a royal pain I can only give you a screenshot. But i have also attached working example in form of a word doc and an outlook template: https://drive.google.com/drive/folders/1EYAR5GzIEw8YatGZ_wGsBXNfxf4BV8HI?usp=sharing
Unfortunately field codes don't seem to have anything to get the day of the week as a number. So in my example I have referenced english day names, you may need to adjust accordingly.
Hope this helps.
Cheers
Screen shot of field code
answered Jan 11 at 10:06
chiwichiwi
662
662
Whoow thanks, this looks really promising. I'll need to take a better look, but for now many thanks. Furthermore, in terms of Stack overflow policies, the actual answer should be embedded in your post and not be a linked resource (in case the link goes down). Could you edit the post a little so the essential parts of the answer are visible here?
– Neograph734
Jan 12 at 11:24
add a comment |
Whoow thanks, this looks really promising. I'll need to take a better look, but for now many thanks. Furthermore, in terms of Stack overflow policies, the actual answer should be embedded in your post and not be a linked resource (in case the link goes down). Could you edit the post a little so the essential parts of the answer are visible here?
– Neograph734
Jan 12 at 11:24
Whoow thanks, this looks really promising. I'll need to take a better look, but for now many thanks. Furthermore, in terms of Stack overflow policies, the actual answer should be embedded in your post and not be a linked resource (in case the link goes down). Could you edit the post a little so the essential parts of the answer are visible here?
– Neograph734
Jan 12 at 11:24
Whoow thanks, this looks really promising. I'll need to take a better look, but for now many thanks. Furthermore, in terms of Stack overflow policies, the actual answer should be embedded in your post and not be a linked resource (in case the link goes down). Could you edit the post a little so the essential parts of the answer are visible here?
– Neograph734
Jan 12 at 11:24
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004646%2ffield-for-next-working-day-in-outlook-template-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I think thoses can be help you : stackoverflow.com/q/19711400/9940803
– pascal sanchez
Jan 5 at 21:22
1
Thanks @pascalsanchez I was hoping for a method without macro's, but I will look into it.
– Neograph734
Jan 7 at 10:22
i'm going to find way without any macro's .
– pascal sanchez
Jan 7 at 10:26