Help
Where am I going wrong.
Sending an email using VfpExMapi()
LParameters lcLink
lcMessage = "To: " + Alltrim(Employee.cFullName) + "." + Chr(13) + ;
"Please note that an Arnold Wills Purchase Order has been created by "
+ Alltrim(oGlobal.cLogginName) + "." + Chr(13) + ;
"Click on this link to view it. " + '"' + "File://" + lcLink + '"'
lcSubject = "Ref: Purchase Order No. " + JustStem(lcLink)
lcEmail = Alltrim(Employee.Email)
VfpExMapi(lcEmail,"","TO",lcMessage,lcSubject)
Where lcLink is the full path and name of an Excel spread sheet.
So I call this procedure with
ThisForm.SendEmails("N:\AWPurchaseOrderSystem\XLPO's\UniqueTrading\MSBP-MB-8
335 01-10-2010.xls")
In the email I get.
To: David Couldwell.
Please note that an Arnold Wills Purchase Order has been created by Peter
Hart.
Click on this link to view it.
"File://N:\AWPurchaseOrderSystem\XLPO's\UniqueTrading\MSBP-MB-8335
<File:///N:\AWPurchaseOrderSystem\XLPO's\UniqueTrading\MSBP-MB-8335>
01-10-2010.xls"
Note the link has stopped before the space.
This next email was produced by putting a hyphen where the space was in the
call as well as changing the spread sheet name.
To: David Couldwell.
Please note that an Arnold Wills Purchase Order has been created by Peter
Hart.
Click on this link to view it.
"File://N:\AWPurchaseOrderSystem\XLPO's\UniqueTrading\MSBP-MB-8335-01-10-201
0.xls
<File:///N:\AWPurchaseOrderSystem\XLPO's\UniqueTrading\MSBP-MB-8335-01-10-20
10.xls> "
That worked OK so I could get the application to replace spaces when it
saves the spread sheet, but they have been producing PO's for 3 months now
so a lot of sheets would have to be renamed as well.
I tried putting square brackets and single quotes round the link but that
did not work either.
The second question is about "Inno" scripts.
I am trying to put some system dll's and ocx's into the system32 folder and
register them but I get an error. What should I be doing. And should I be
putting them there or should I put them in the app directory , If so can I
make them read only. I have put a dbf in the app directory where it gets
picked up by the exe on start up. Tried setting it "System" or "Hidden" but
FoxPro can't see it, just says it cannot find DB_Loc'n.dbf Works OK if I
unhide it. I am trying to stop prying eyes seeing it and deleting it. What
are the best practices?
T.I.A.
Peter
Peter Hart Computers
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
