Hi
Could anybody tell me how to add an additional colour to this code
at the moment if text is entered with N-SIDE all the related cells will go yellow
I have been trying to add it the text is...
Type: Posts; User: peter renton
Hi
Could anybody tell me how to add an additional colour to this code
at the moment if text is entered with N-SIDE all the related cells will go yellow
I have been trying to add it the text is...
Hi
I hope sombody can assist me in tweaking this code.
In The attached workbook,emails will be sent if the task in any sheet is due, they are only sent when the book is first ,once the date in a1...
Thank You p45cal
That's just what I was looking for, makes it look a lot better,
Cheers Peter
Hi
Is there a way to make the top row of the table that is imported into the emails in this code a different colour?
I have tried to add normal html codes but these come up with a syntax...
sorry Bakerman
I meant to cross reference, I have added links on both sites
Thanks
Hi
Could anybody help me with the reason why the table is not been shown when the due today text is entered.
At the moment it will send an email with the table if the dates are over due and the...
Hi
Dont know if this can be done or not.
i am wanting the auto email code to pick up all the email address in the selected list and add them into the cc email.
if tou look at the ppe sheet...
Thanks Bakerman
that works spot on, i would never have got there in a month of sundays
thanks also alan for your assistance..
Peter:-)
Hi Alan
Thanks for looking
comes up with a runtime error on start up....method rows of object global failed..
with this row highlighted (Set rng = w.Range("F4:F50" & w.Range("F" &...
Hi Alan
I have tried every which way to try and get this thing to do what i want but keep screwing it up (i must be thick as it is probably very simple)
the attached selects the ppe sheet and...
hi
do i just need to add this at the begining of my existing code removing the select ppe row and the next w at the end or
do i need new code as well
i am just trying to get my head around...
Hi
Code anybody help me to loop through the sheets.
at the moment the code will look at ppe sheet and check the dates if any due date are found it generates an email and inserts a table in it....
Hi I posted the link below in the outlook forum but maybe it should have been in here
i can add a linkk to thr dropox to show full wb if this would help
peter
...
Hi
i have the following code that send an email (outlook)with various cell data depending on due date
is there a way to make sure the data transfered and shown in the email is spaced out evenly...
Hi the code below sends an email every time the wb is opened if the due date is today or overdue to the email at the bottom of the code
how can i send the same email to anther one or two emails ?...
Hi
I have added a code that allows column g only to be updated so the emailer need only look at this column
dont know if this makes the process easier??
Peter
bump
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.eileenslounge.com/viewtopic.php?f=44&t=40455&p=313035#p313035
...
Hi
I have attached a trial wb.
I have a code that will send an email depending on a date in column f.
It sends it to the email in the code.
What i am trying to acheive is that when column f...
ok Robert
thanks for trying
Peter
Hi Robert
i have attached a link to the full wb.
I have tried to add you code module 1 (there is aready a code in there) and also added a module two
but when i add y to copy nothing happens and...
Hi
Ihave some other coding in the main wb and when a put this code in it is triggering a duplicated reg checker an goes through every row on the sheet,
how/where do i need to add your code so as...
ok scrap the first line it appears to be working ok now :-)
how do i get the other sheet to copy the same way ?
Thanks for that Robert
I have just been trying it and if i click the macro without changing any thing it copies the last row again?
can i have the used cantrct sheet to copy into the master as...
Hi
I have attached a small wb
when the data is entered on sheet one and the macro is activated (i need this to be automatic but i will start a need thresd for this)
the selected data is coppied...
Hi Robert
I have attached an updated file
i am tring to have certain cell data copied into summary sheet so that the rows can be filtered and these can be calculated to show profit/loss .
At...