Consulting

Results 1 to 3 of 3

Thread: Pull together various pieces of information to prepare email with attachment

  1. #1
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location

    Pull together various pieces of information to prepare email with attachment

    I'm trying to get three pieces of information from Userform input / selection that will then populate an email with subject line, prepared body text and add a single attachment.

    The RMS number will be typed in by the user, the Area selected from a combobox (this will provide the email address too) and the attachment located when clicking on a TextBox. Ideally, if it is possible, would like this to establish where the last document was saved and point to the folder containing it, ready for easy selection.

    Thanks!
    Steve
    Attached Files Attached Files

  2. #2
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    Still looking for some help on putting this together.

    I've got hold of Ron DeBruin's Outlook Open/Close module - http://www.rondebruin.nl/win/s1/outlook/openclose.htm

    I'm using a combobox to populate the Area selection.

    Thanks!
    Attached Files Attached Files

  3. #3
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    I'm nearly there with this one, but will need some help and guidance on how to establish where the last document was saved and point to the folder containing it, ready for easy selection to add as an attachment.

    Thanks!
    Steve
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •