Search:

Type: Posts; User: peter renton

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    1,449

    add an addition cell colour to coding

    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...
  2. excel to send emails to specified addesses determined by due date

    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...
  3. Thank You p45cal That's just what I was...

    Thank You p45cal

    That's just what I was looking for, makes it look a lot better,


    Cheers Peter
  4. change table top row to a different colour with html code

    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...
  5. sorry Bakerman I meant to cross reference, I...

    sorry Bakerman

    I meant to cross reference, I have added links on both sites


    Thanks
  6. How To Embed An Excel Table In To An Outlook Email Body

    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...
  7. select email address from cell and add to cc email

    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...
  8. Thanks Bakerman that works spot on, i would...

    Thanks Bakerman

    that works spot on, i would never have got there in a month of sundays

    thanks also alan for your assistance..

    Peter:-)
  9. Hi Alan Thanks for looking comes up with a...

    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" &...
  10. Hi Alan I have tried every which way to try...

    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...
  11. hi do i just need to add this at the begining...

    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...
  12. setting loop code to check all named sheets

    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....
  13. how-to-transfer-data-from-excel-into-outlook-in-controled-columns

    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
    ...
  14. how to transfer data from excel into outlook in controled columns

    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...
  15. Send Same Email To More Than One Person Or Multiple Recipients

    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 ?...
  16. Hi I have added a code that allows column g...

    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
  17. bump ...

    bump

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.eileenslounge.com/viewtopic.php?f=44&t=40455&p=313035#p313035
    ...
  18. sending e mails from excel via outlook at diferent stages depending on cell data

    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...
  19. ok Robert thanks for trying Peter

    ok Robert

    thanks for trying


    Peter
  20. Hi Robert i have attached a link to the full...

    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...
  21. Hi Ihave some other coding in the main wb 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...
  22. ok scrap the first line it appears to be working...

    ok scrap the first line it appears to be working ok now :-)

    how do i get the other sheet to copy the same way ?
  23. Thanks for that Robert I have just been trying...

    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...
  24. Code not finding unique number causing duplication of data

    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...
  25. Replies
    5
    Views
    1,442

    Hi Robert I have attached an updated file i...

    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...
Results 1 to 25 of 84
Page 1 of 4 1 2 3 4