Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA code to create a list of selected items

    My wife is a member of a group who do all their work by email. Monthly she wishes to create a correspondence list (inwards / outwards) and discovered she was continually copying data just to present it as a summary.

    The attached VBA code operates on the currently selecteed items and creates a little summary email. I thought it may be useful to others with a similar requirement.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA code to create a list of selected items

    Thanks!

  3. #3
    Lounger
    Join Date
    Feb 2005
    Location
    Florida, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA code to create a list of selected items

    Hi Anrew,

    Thanks for the code!

    Is there a way to attach a sample file to show what the code's output looks like?

    Thanks' again.

    -Tivoli0

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA code to create a list of selected items

    Why don't you try the code? (Please read the warning in AndrewO's attachment - you'll have to use Edit | Replace to change it a bit)
    The code displays an e-mail on the screen, it doesn't send it automatically, so you can safely try it out.

  5. #5
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA code to create a list of selected items

    Attached word document has a paste of the email message content.
    I couldn't see a way to attach the message itself
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA code to create a list of selected items

    > I couldn't see a way to attach the message itself

    You can save an e-mail as a .htm or .msg file, zip this file and attach the zip file to a post. (You can't attach a .htm or .msg file directly)

  7. #7
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA code to create a list of selected items

    Thanks Hans.
    The other issue was that I actually had to send it for it to become formated as a mail message. Before a send it knows its a word document.
    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
  •