vba sending email via Groupwise

[conti]

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.

[Zack Barresse]

Hi there,

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...

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

2. How to begin a new line on vba ;

Like so...

vbNewLine

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?

[conti]

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...

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...

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..

[Zack Barresse]

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.