Macro question

[Anonymous]

While using Application.MailSend in a macro, i am getting the error :
Project requires Outlook or another MAPI-complaint electronic mail program.
We have Lotus notes e-mail system and we do not use Outlook. Can i write the
code in a macro which will work for Lotus notes e-mailing system? If yes how
can i do that. Please refer the code snippet below:
----------------------------------------------------------

Private Sub SetNumber13(ByVal pj As Project)
Dim wTask As Task

If pj.ProjectSummaryTask.BCWS = 0 Then
pj.ProjectSummaryTask.Number13 = 1
Else
pj.ProjectSummaryTask.Number13 = pj.ProjectSummaryTask.SPI

If pj.ProjectSummaryTask.Flag1 = True Then

If pj.ProjectSummaryTask.Number13 <>
pj.ProjectSummaryTask.Number16 Then

Application.MailSend To:="Rajesh Sharma,Anuya Sheorey", _
Subject:="Schedule indicator changed", _
Body:="Schedule indicator changed", _
IncludeDocument:=False, _
ReturnReceipt:=True
pj.ProjectSummaryTask.Flag1 = False
End If
End If
End If

For Each wTask In pj.Tasks
If wTask.Milestone Then
wTask.Number13 = -1
Else
If wTask.BCWS = 0 Then
wTask.Number13 = 1
Else
wTask.Number13 = wTask.SPI
End If
End If
Next

End Sub

 

[Gary L. Chefetz \(MVP\)]

On the machine you're runing this on, you need to create a profile for
Notes. The Notes installation does not do this by default, and other MAPI
compliant programs can't find the Notes client until it has a profile on the
machine.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

 

[Anonymous]

Shall i setup the profile as mentioned in :
http://www-1.ibm.com/support/docvie...df85256cc200635036&loc=en_US&cs=utf-8&lang=en

And after i do this will i be able to send e-mail through the macro?

On the machine you're runing this on, you need to create a profile for
Notes. The Notes installation does not do this by default, and other MAPI
compliant programs can't find the Notes client until it has a profile on the
machine.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

 

[Gary L. Chefetz \(MVP\)]

After you do this, Project will be able to connect to your GAL through
Notes. Whether or not your macro works is another subject.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

Shall i setup the profile as mentioned in :
http://www-1.ibm.com/support/docvie...df85256cc200635036&loc=en_US&cs=utf-8&lang=en

And after i do this will i be able to send e-mail through the macro?

 

[Anonymous]

Hi Gary,

I now have the macro working with notes. When the project is saved
on the local machine it sends an e-mail using local notes database.
I tend to believe that when the project is saved on the project
server it will try to find the notes on the server and then i would
require a notes database there also. Is this correct? I know that
PWA uses SMTP mail server for sending e-mails. Would i be able to
communicate through the SMTP mail server within the macro? I am
looking for an option which works without additional installations
and settings. Are there any other options?

Thank for all the help!!
Rajesh D. Sharma

 

[Gary L. Chefetz \(MVP\)]

Rajesh:

As far as email generated by Project Server and SharePoint, all you have to
do is point those applications at your SMTP service. If it's Notes, then
point it to the Notes Server. Make sure that your server is configured to
accept relays from the Project Server and WSS box or boxes.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-