vba sending email via Groupwise

conti

New member
Joined
Jan 11, 2014
Messages
7
Reaction score
0
Points
0
Hi !

I tried your vba here http://www.excelguru.ca/content.php?165-Send-Email-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

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
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...

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

2. How to begin a new line on vba ;
Like so...

Code:
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

New member
Joined
Jan 11, 2014
Messages
7
Reaction score
0
Points
0
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..
 

Zack Barresse

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
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.
 
Top