Recent content by jillnoble

  1. J

    Export report to separate PDF's

    Thing is, if I try and rerun it everyone up to the issue gets the same thing again! Is there anyway of putting them in my drafts so I can then send???
  2. J

    Export report to separate PDF's

    Omg! I thought I'd checked and double checked! Now getting an issue where it stop when no email address entered (we have some names on the DB which do not receive Pay slips) but not an issue, I can just put mine in there!! Thanks again
  3. J

    Export report to separate PDF's

    Hiya, I thought I was sorted, even did a trial run at the weekend but now coming to run them for real and getting the attached errors.. This is the code on the form (not sure I uploaded it properly)... Any ideas please? Option Compare Database Option Explicit Dim OutlookApp As...
  4. J

    Export report to separate PDF's

    Don't worry about previous response, I think I've sussed it due to Gasman's comment. If I actually knew anything about code I would've realised that. I'd just like to say you're my hero!! 🦸‍♂️
  5. J

    Export report to separate PDF's

    OMG!! That worked! Thank you so much! 😊😊😊😊😊😊😊
  6. J

    Export report to separate PDF's

    Thank you - Do you ever sleep! I've added that but still getting errors. If you're determined to help, which is appreciated, I have reattached your version with the code and reference added...
  7. J

    Export report to separate PDF's

    Thank you so much again for holding my hand through this but I tried this and got the attached, I've tried going onto the other posts/the internet to investigate and changed bits around/add/deleted bits but I always seem to come up against other errors. Honestly, I really appreciated everything...
  8. J

    Export report to separate PDF's

    You're all brilliant - Thank you!
  9. J

    Export report to separate PDF's

    You're all brilliant - Thank you!
  10. J

    Export report to separate PDF's

    That is exactly what I need, thank you so much for coming to my rescue yet again!! Not wanting to push my luck, but I have this found this command on the internet - DoCmd.SendObject acsendNoObject,,,"jillnoble@tubesscaffolding.co.uk",,,"Wage Slip Breakdown","Please find attached your wage slip...
  11. J

    Export report to separate PDF's

    Arh, I see what u mean, once you know the company name you can get all those details from companies house anyway so didn’t think that would be a problem. But yes, see what u mean about Keith and the wages. My mistake and am very sorry. Just didn’t know how else to get the help I needed. Apologies.
  12. J

    Export report to separate PDF's

    Ok Uncle Gizmo, no problem. I thought it would be ok as no addresses, email addresses, phone numbers etc (except mine) only random names. However, I totally understand. Thank you
  13. J

    Export report to separate PDF's

    Thank you so much but I’ve kinda lost the Will to live with it at the moment! This looks great but I don’t even know where to put it! Like I’ve said to thedbguy, I think I’m going quite a way out of my understanding. Thanks for trying though!
  14. J

    Export report to separate PDF's

    Thank you DBguy but I think this may be a bit above me. I can’t even get the outputto to work! I’ve googled it, Copied, pasted and amend to my own names etc on several different versions (I assume I put that in the vba of the report?) I think I may have to think of another way round. I may just...
  15. J

    Export report to separate PDF's

    Hi, This discussion seems to have been covered several times in many places, so I'm sorry if I've out this in the wrong place! I've been trying for a few days but no matter what code I use I cannot get it to work. I am very unfamiliar with code as I only set this DB up as a favour for work...
Top Bottom