[SOLVED] calling novel groupwise email with macro

[rjardine1]

I have seen a few examples of calling outlook email with a macro.
I have tryed to addapt the code for groupwise but I am obviously missing something.
I do have a code which calls a generic email and that does call the groupwise but I have not been able to adapt the auto fill in of the subject: and send to : lines.

Code: Select all

' send copy to communications by email

  Application.Dialogs(xlDialogSendMail).Show

This code opens groupwise and attaches the open excel file but all the other fill ins to send the email are blank.

Russ

[charles]

Russ,

Welcome to the forum.
I'm not sure what you mean by "Group wise".
And too I'm not too versed with sending email, but check this site.
It may help you. If not come on back and we'll do what we can for you.

http://www.rondebruin.nl/tips.htm

[Sisyphus]

Hello Russ,
I don't have any experience in what you are trying to do, but I would understand some one arguing that there is no need for the capability to send group mails by VBA.
The argument would run along the lines that a group is the result of a query. Using code it might be easier to simulate the query than to access its result.
I imagine a list of contacts. This list would have a column for "Group", and in that column the group name would be recorded against each member of a group, perhaps an array of groups if some one is a member of many groups. So, you might recover the group members by filtering the list of contacts by their Group property.
I don't know how much of this is just phantasy, but perhaps the idea guides your efforts away from where you are now stuck.

[charles]

Hi,

As Sisyphus' suggested the "Array" this may help

Code: Select all

Application.Dialogs(xlDialogSendMail).Show _
arg1:=Array("dklann@lineone.net", "jdoe@acme.com", "someoneelse@somewhere.com"), _
arg2:="test email"


[rjardine1]

I will give your code a try, Novell Groupwise is a very widely used email system in large corporations in Canada and USA.



Novell GroupWise
GroupWise collaboration software is a premier collaboration tool for large enterprise. Look no further than Novell for your collaboration software.
www.novell.com/products/groupwise/

I just found there forum so I hope I get some help there. Of course I will be back because the people on this site are a great help with so many questions.
Russ

[lion8538]

The art of being wise is the art of knowing what to overlook!

[rjardine1]

I solved the problem with this code

Code: Select all

 Application.Dialogs(xlDialogSendMail).Show _
arg1:="first address@place.com" & ";" & "second address@place.com" & ";" & "third address@place.com", _
arg2:="North attributes" & Now()