Results 1 to 4 of 4

Thread: vba sending email via Groupwise

  1. #1

    vba sending email via Groupwise



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi !

    I tried your vba here http://www.excelguru.ca/content.php?...-Via-Groupwise and everything is ok!

    I 'm just wondering if it is possible:

    1. write the fields To,BB,BCC, Subject,Body,Attachment in various ranges of Excel and non directly in the code;

    2. How to begin a new line on vba ;

    3. seeing the window of Groupwise created and push Send from there and not immediately sent from excel.

  2. #2
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Hi there,

    Quote Originally Posted by conti View Post
    1. write the fields To,BB,BCC, Subject,Body,Attachment in various ranges of Excel and non directly in the code;
    Do you see how the function takes a string argument to pass these items? Just reference a cells value which contains this information to get it to work. So you could reference cells like this...

    Code:
    Sub foo()
    
        Dim WS                      As Worksheet
        Set WS = ActiveSheet
        Call Email_Via_Groupwise(WS.Range("Login Name").Text, _
                                 WS.Range("Email To").Text, _
                                 WS.Range("Email Subject").Text, _
                                 WS.Range("Email Body").Text, _
                                 WS.Range("Email Attachments").Text, _
                                 WS.Range("Email CC").Text, _
                                 WS.Range("Email BCC").Text)
    
    
    End Sub
    Quote Originally Posted by conti View Post
    2. How to begin a new line on vba ;
    Like so...

    Code:
    vbNewLine
    Quote Originally Posted by conti View Post
    3. seeing the window of Groupwise created and push Send from there and not immediately sent from excel.
    The code should send the email. Not sure why it wouldn't be. I don't have GroupWise to test with however. What behavior are you seeing?
    Regards,
    Zack Barresse

  3. #3
    Quote Originally Posted by Zack Barresse View Post
    Hi there,


    Do you see how the function takes a string argument to pass these items? Just reference a cells value which contains this information to get it to work. So you could reference cells like this...

    Code:
    Sub foo()
    
        Dim WS                      As Worksheet
        Set WS = ActiveSheet
        Call Email_Via_Groupwise(WS.Range("Login Name").Text, _
                                 WS.Range("Email To").Text, _
                                 WS.Range("Email Subject").Text, _
                                 WS.Range("Email Body").Text, _
                                 WS.Range("Email Attachments").Text, _
                                 WS.Range("Email CC").Text, _
                                 WS.Range("Email BCC").Text)
    
    
    End Sub

    Like so...

    Code:
    vbNewLine

    The code should send the email. Not sure why it wouldn't be. I don't have GroupWise to test with however. What behavior are you seeing?
    3. What behavior are you seeing?

    If you tried "Rondebruin" for outlook, You can see that when you push SEND, there is not an automatic sending, but this opens the window of Outlook, You see your text,attachment,etc and then you can push send but from outlook not from excel..

  4. #4
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    I'm a little confused. I have used Ron de Bruin's code, yes, although I generally tend to write my own. I know of a few methods to send emails, and by default with OUTLOOK you'll get a security warning. Programs tend to not want to let you send emails automatically when generated from code, something about spamming and all.

    Check out Ken Puls knowledge base article here: http://vbaexpress.com/kb/getarticle.php?kb_id=277

    Other than that I don't know how to help you, other than tell you to upgrade to Outlook.
    Regards,
    Zack Barresse

Posting Permissions

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