Hi there,

Originally Posted by
conti
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

Originally Posted by
conti
2. How to begin a new line on vba ;
Like so...

Originally Posted by
conti
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?
Bookmarks