Consulting

Results 1 to 5 of 5

Thread: Add subject, body, and attachments to emails thru excell/groupwise

  1. #1
    VBAX Newbie
    Joined
    Jun 2009
    Posts
    3
    Location
    Does anyone know how to add subject, body, and attachments to my emails thru excell/groupwise
    Last edited by mdmackillop; 06-12-2009 at 12:32 AM. Reason: Moved to new thread

  2. #2
    VBAX Newbie
    Joined
    Jun 2009
    Posts
    3
    Location

    Assign the SUBJECT text

    Does anyone know how to assign subject text. I am also needing to add an attachment and body to emails sent thru excell. I am working with groupwise.

  3. #3
    VBAX Newbie
    Joined
    Jun 2009
    Posts
    3
    Location

    HElp

    [VBA]
    With ogwNewMessage
    'Assign the SUBJECT text
    If Not StrSubject = "" Then .Subject = StrSubject

    'Assign the BODY text
    If Not StrBody = "" Then .BodyText = StrBody

    'Assign Attachment(s)
    If Not strAttachFullPathName = "" Then .Attachments.Add strAttachFullPathName
    [/VBA]

    Can someone please explain this to me.. Im needing to add a subject, BODY, and Attachment. Im a newbie so im a little lost..

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    What do you need explaining, that code does what you ask?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Threads merged as they all ask the same question!
    awdw03 please refrain fromasking the same question multiple times, it makes it difficult for those giving up their free time helping you to keep track of the responses.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

Posting Permissions

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