• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

Problem with @Mailsend

Hi, I have designed a Travel Request form and created some buttons to send mails using @Mailsend command, when a mail goes to the approver he is suppose to open the link in the mail created by [INCLUDEDOCLINK] flag, User needs to open the link and click on another  button to approve the request, this should triger another set of mails with @Mailsend command.

Now the problem is that when user opens the form with the help of link mail dosn't go, but if he click the button by opening the form from the database mail goes without any problem, Pls help..

Button codes is as follows

J:=@GetField("Approv_1");
N:=@GetField("NAMET");
A:="<Travel Requester>" + @GetField("NAMET");
B:="<Chargecode>" + @GetField("CC");
C:= "<Destination>" + @GetField("Dest");
D:="<Official Stay Duration>" + @GetField("Stay");
F:="<Purpose>  " + @GetField("Purpose");
E:= A+B+D+C;
@Command( [EditDocument]; "1" );
@MailSend(J;N;"prashant bhatnagar";E + ": Your 'Travel Request' is approved and sent for final approval to Account's Manager..Thanks";"";"Please process the 'Travel Request'. Thanks. For any details about this Travel Request status, click on the following Doc Link.";[IncludeDoclink]);
@SetField("StatusT";"Approved By Manager");
@SetField("By";@Name([CN];@UserName));
@SetField("ApproveDT";@Now([ServerTime]));
@Command([FileSave]);@Command([FileCloseWindow])
0
Prashantbhatnagar
Asked:
Prashantbhatnagar
  • 6
  • 3
  • 3
  • +3
1 Solution
 
madheeswarCommented:
Prashant,
I am not clear here .....
"Now the problem is that when user opens the form with the help of link mail dosn't go, but if he click the button by opening the form from the database mail goes without any problem, Pls help..
"

can u pls try explaining?
0
 
Steve KnightIT ConsultancyCommented:
Bit confused too.  You can't include a doclink to a document that hasn't been saved.  If this is a new document it needs to be saved first, but not sure what you are actually doing...

Steve
0
 
PrashantbhatnagarAuthor Commented:
When a user apply for travel, he needs toget it approved from his manager, so a mail goes with link of the form to the manger, when manager clicks the link form opens from the database and he needs to click a button with above mention code - a mail should go to set of e-mail id, which is not happening. But when I or manager tries doing the same directly from the database it works..

I hope explains

Prashant
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
PrashantbhatnagarAuthor Commented:
Document is already created and saved by the user with the help of another button codes as follows

N:=@GetField("Approv");
A:="<Name>" + @GetField("NAMET");
B:="<Chargecode>" + @GetField("CC");
C:= "<Official Stay Duration:>" + @GetField("Stay");
D:="<Destination>" + @GetField("Dest");
F:="<Purpose>  " + @GetField("Purpose");
E:= A+B+D+C;
@Command( [EditDocument]; "1" );
@MailSend(N;"Mc_Accounts";"";E+" Please approve my Travel Request by opening the link in the mail and clicking the approved button..Thanks";"";F+ "..............................................................................................................................................................................................       : Please approve my  Travel Request by opening the link in the mail and clicking the approved button....Thanks";[DELIVERYREPORTCONFIRMED]:[IncludeDoclink]);
@SetField("StatusT";"Pending For Approval");
@Command([FileSave]);@Command([FileCloseWindow])
0
 
PrashantbhatnagarAuthor Commented:
This button is working perfectly fine as the doicument is created and send from the database itself..

Prashant
0
 
madheeswarCommented:
Are you setting the Approving Person name some where on the form? If not, first store it in a field and make use of it when the Approving person approves.

0
 
PrashantbhatnagarAuthor Commented:
Yes, I,m storing it on the form, even if I put the e-mail id in the @mailsend command then also it does not work...
0
 
madheeswarCommented:
First try this.. and once it is working then let me know.
A:="<Travel Requester>" + @GetField("NAMET");
B:="<Chargecode>" + @GetField("CC");
C:= "<Destination>" + @GetField("Dest");
D:="<Official Stay Duration>" + @GetField("Stay");
F:="<Purpose>  " + @GetField("Purpose");
@Command( [EditDocument]; "1" );
@MailSend(Approv_1;NAMET;"prashant bhatnagar"; ": Your 'Travel Request' is approved and sent for final approval to Account's Manager..Thanks";"";"Please process the 'Travel Request'. Thanks. For any details about this Travel Request status, click on the following Doc Link.";[IncludeDoclink]);
@SetField("StatusT";"Approved By Manager");
@SetField("By";@Name([CN];@UserName));
@SetField("ApproveDT";@Now([ServerTime]));
@Command([FileSave]);@PostedCommand([FileCloseWindow])
0
 
PrashantbhatnagarAuthor Commented:
Same issue, its not working if accessed from the link in the memo, if form is opened directly then it works.

Prashant
0
 
SysExpertCommented:
Time to convert it to lotus script so that it can be properly debugged !!

see
http://www.experts-exchange.com/Applications/Email/Lotus_Notes_Domino/Q_21444035.html

and
http://www.experts-exchange.com/Applications/Email/Lotus_Notes_Domino/Q_20417335.html

for a sample.

I hope this helps !
0
 
shuboarderCommented:
Hi,

I had a similar problem recently:
http://www.experts-exchange.com/Applications/Email/Lotus_Notes_Domino/Q_22022036.html

It appears that [Includedoclink] is not all that well supported with the @mailsend command.
See the comments posted by Sjef in the above link!

Make sure your database has a default view
- If you still don't have any luck then perhaps try Lotus Script instead.

Hope this helps!
0
 
Sjef BosmanGroupware ConsultantCommented:
:-))
0
 
Steve KnightIT ConsultancyCommented:
Interesting choice of answer!
0
 
PrashantbhatnagarAuthor Commented:
Sorry,

I think I got the clue from

Comment from sjef_bosman
Date: 10/24/2006 02:04AM PDT
 Comment  


http://www-1.ibm.com/support/docview.wss?rs=0&uid=swg21090662
http:Q_20697221.html "Doclink database cannot be located"

When you know the solution it's easy to find other references...
 
Comment from Prashantbhatnagar
Date: 11/10/2006 03:55AM PST
 Your Comment  


Great , It worked, the issue was default view was declared.

Thanks a lot for you help sjef_bosman

Regards
Prashant
0
 
Steve KnightIT ConsultancyCommented:
Thought so ... just meant it was best to post why though or it looks odd when looking back at the paqs.
0
 
Sjef BosmanGroupware ConsultantCommented:
You're very welcome, but I think you should have accepted shuboarder's comment, for having pointed you at the right answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 3
  • 3
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now