 |
VFP ·R¥ÎªÌªÀ°Ï ¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
¤ý«Ø¶Q
µù¥U®É¶¡: 2004-03-11 ¤å³¹: 62
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤¤ë 15, 2004 3:56 pm ¤å³¹¥DÃD: VFP6¦³¨S¦³¹³Outlookªº¦æ¨Æ¾ä.Activex±±¨î¶µ? |
|
|
¤½¥qn¼g¤@Ó¹³Outlookªº¦æ¨Æ¾äªº·|û±Æ½Ò¨t²Î.½Ð±Ð¦U¦ì¤j¤j.vfp6¦³³oÓActivex±±¨î¶µ¶Ü? |
|
¦^³»ºÝ |
|
 |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 2 ¼Ó
|
|
¦^³»ºÝ |
|
 |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 3 ¼Ó
|
|
¦^³»ºÝ |
|
 |
¤ý«Ø¶Q
µù¥U®É¶¡: 2004-03-11 ¤å³¹: 62
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤¤ë 18, 2004 3:18 pm ¤å³¹¥DÃD: |
|
|
¦Û¤v¼g®£©È¥\¤O¤£°÷.¤p§Ì·Qª½±µ¥ÎOutlookªº¦æ¨Æ¾ä.¦ý¬O§Ú¥Î¦æ¨Æ¾ä·j´M¾ãӤ峹.¨S¬Ý¨ì.¥ÎOutlook·j´M³£¬O¤¶²Ðmail¤è±ªº¤å³¹.½Ð±Ðgoto-dream¤j¤j.¥i¥H«ü¾É¤@¤U£v.ÁÂÁÂ! |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤¤ë 18, 2004 3:32 pm ¤å³¹¥DÃD: |
|
|
¬Ý¨Ó¥i¯à·|¹³¾Þ§@excel ¤@¼Ë,
createobject()«Ø¤@Óoutlookª«¥ó,
¦A«Ø¤@Ó¦æ¨Æ¾ä§a,
§Ú²qªº _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
 |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 6 ¼Ó
|
|
¦^³»ºÝ |
|
 |
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤¤ë 18, 2004 3:35 pm ¤å³¹¥DÃD: |
|
|
µ¹§A¦U±H«H½d¨Ò.»¡©ú¬O²Åé¦r.
¤Þ¨¥¦^ÂÐ: |
*-- ÈçºÎ×Ô¶¯Ìí¼ÓÁªÏµµ½ Outlook
#DEFINE olFolderContacts 10
#DEFINE olCurrency 14
#DEFINE olPercent 12
LOCAL loOutlook, loNameSpace, loFolder, loContact, loNewContact
*!* »ñÈ¡¶Ô Outlook µÄ¶ÔÏóÒýÓÃ
loOutlook = CREATE("Outlook.Application")
*!* »ñÈ¡ MAPI namespace (½öÒ»¿ÉÓõÄÒ»¸ö)
*!* ²¢ÕÒµ½ÁªÏµÈËÎļþ¼Ð
loNamespace = loOutlook.GetNameSpace("MAPI")
loFolder = loNameSpace.GetDefaultFolder(olFolderContacts)
*!* ÔÚ±ê×¼ÁªÏµÈËÎļþ¼ÐÏÂÌí¼ÓÒ»¸ö×ÓÎļþ¼Ð
loContact = loFolder.folders.Add("ÁªÏµÈË")
sele temp
SCAN
loNewContact = loContact.Items.Add() && ·µ»ØÒ»¸ö ContactItem Àà±ð¶ÔÏó
WITH loNewContact
.FullName = xm
.JobTitle = dh
.CompanyName = email
*!* Õâʹ company name ³öÏÖÔÚ Outlook ÖÐµÄ contact name µÄÉÏÃæ.
*!* ËüÒ²°´ company name ÅÅÐò.
.FileAs = .CompanyName + " (" + ;
ALLTRIM(.FullName) + ")"
*!* ²»ÐÒµÄÊÇ, Contacts ±í²»°üÀ¨ email.
*!* ×¢Òâ: ÒÔÏÂÊôÐÔÊÇ Email Ò»¸öµØÖ·. ÔÚijЩ×ÖÌåϲ»Çå³þ.
.Email1Address = "random@nospam.com"
.Email1AddressType = "SMTP"
lcAddress = ALLTRIM(gzdwdz) + CHR(10) + ;
ALLTRIM(gzyb) + ;
ALLTRIM(gzyb)
.HomeAddress = lcAddress
.BusinessTelephoneNumber = ALLTRIM(jtdh)
.BusinessFaxNumber = ALLTRIM(fax)
*!* Ϊ¶îÍâµÄ×ֶδ´½¨Óû§¶¨ÒåÊôÐÔ
.UserProperties.Add("Max Order Amount", olCurrency)
.UserProperties.Add("Min Order Amount", olCurrency)
.UserProperties.Add("Discount", olPercent)
*!* Èç¹ûÄãÔÚÕâÀïʹÓÃÊýÖµË÷Òý (1, 2 ºÍ 3) Äã»á·¢ÏÖ¼¯ºÏÊÇ×ÖĸÐÍ.
discount = 100
max_order_amt = 200
min_order_amt = 10
.UserProperties("Discount").Value = ROUND(discount / 100, 2)
.UserProperties("Max Order Amount").Value = max_order_amt
.UserProperties("Min Order Amount").Value = min_order_amt
*!* ContactItem ÔÚδ±£´æÇ°²»»á³öÏÖÔÚ Outlook ÖÐ.
.Save
ENDwith
ENDscan
|
_________________ ºÖ¶©©÷²b¤ô¦³¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!
·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.
¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú |
|
¦^³»ºÝ |
|
 |
¤ý«Ø¶Q
µù¥U®É¶¡: 2004-03-11 ¤å³¹: 62
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤¤ë 18, 2004 4:30 pm ¤å³¹¥DÃD: |
|
|
ÁÂÁ¦U¦ì¤j¤j.§Ú¥u¦³¨ìOutlook¬Ý¬Ý»¡©ú.¬Ý¦³¨S¦³¿ìªk¦A»¡Åo.. |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤¤ë 18, 2004 4:58 pm ¤å³¹¥DÃD: |
|
|
¥NÂàÁcÅé:
------------------------------
*-- ¦p¦ó¦Û°Ê²K¥[Ápô¨ì Outlook
#DEFINE olFolderContacts 10
#DEFINE olCurrency 14
#DEFINE olPercent 12
LOCAL loOutlook, loNameSpace, loFolder, loContact, loNewContact
*!* Àò¨ú¹ï Outlook ªº¹ï¶H¤Þ¥Î
loOutlook = CREATE("Outlook.Application")
*!* Àò¨ú MAPI namespace (¶È¤@¥i¥Îªº¤@Ó)
*!* ¨Ã§ä¨ìÁpô¤H¤å¥ó§¨
loNamespace = loOutlook.GetNameSpace("MAPI")
loFolder = loNameSpace.GetDefaultFolder(olFolderContacts)
*!* ¦b¼Ð·ÇÁpô¤H¤å¥ó§¨¤U²K¥[¤@Ó¤l¤å¥ó§¨
loContact = loFolder.folders.Add("Ápô¤H")
sele temp
SCAN
loNewContact = loContact.Items.Add() && ªð¦^¤@Ó ContactItem Ãþ§O¹ï¹³
WITH loNewContact
.FullName = xm
.JobTitle = dh
.CompanyName = email
*!* ³o¨Ï company name ¥X²{¦b Outlook ¤¤ªº contact name ªº¤W±.
*!* ¥¦¤]«ö company name ±Æ§Ç.
.FileAs = .CompanyName + " (" + ;
ALLTRIM(.FullName) + ")"
*!* ¤£©¯ªº¬O, Contacts ªí¤£¥]¬A email.
*!* ª`·N: ¥H¤UÄݩʬO Email ¤@Ó¦a§}. ¦b¬Y¨Ç¦rÅé¤U¤£²M·¡.
.Email1Address = "random@nospam.com"
.Email1AddressType = "SMTP"
lcAddress = ALLTRIM(gzdwdz) + CHR(10) + ;
ALLTRIM(gzyb) + ;
ALLTRIM(gzyb)
.HomeAddress = lcAddress
.BusinessTelephoneNumber = ALLTRIM(jtdh)
.BusinessFaxNumber = ALLTRIM(fax)
*!* ¬°ÃB¥~ªº¦r¬q³Ð«Ø¥Î¤á©w¸qÄÝ©Ê
.UserProperties.Add("Max Order Amount", olCurrency)
.UserProperties.Add("Min Order Amount", olCurrency)
.UserProperties.Add("Discount", olPercent)
*!* ¦pªG§A¦b³o¸Ì¨Ï¥Î¼ÆÈ¯Á¤Þ (1, 2 ©M 3) §A·|µo²{¶°¦X¬O¦r¥À«¬.
discount = 100
max_order_amt = 200
min_order_amt = 10
.UserProperties("Discount").Value = ROUND(discount / 100, 2)
.UserProperties("Max Order Amount").Value = max_order_amt
.UserProperties("Min Order Amount").Value = min_order_amt
*!* ContactItem ¦b¥¼«O¦s«e¤£·|¥X²{¦b Outlook ¤¤.
.Save
ENDwith
ENDscan _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
 |
|
|
±z µLªk ¦b³oÓª©±µoªí¤å³¹ ±z µLªk ¦b³oÓª©±¦^ÂФ峹 ±z µLªk ¦b³oÓª©±½s¿è¤å³¹ ±z µLªk ¦b³oÓª©±§R°£¤å³¹ ±z µLªk ¦b³oÓª©±¶i¦æ§ë²¼ ±z µLªk ¦b³oÓª©±ªþ¥[ÀÉ®× ±z µLªk ¦b³oÓª©±¤U¸üÀÉ®×
|
Powered by phpBB © 2001, 2005 phpBB Group ¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@
|