ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VBA Gmail±H«H°ÝÃD

[µo°Ý] VBA Gmail±H«H°ÝÃD

¦U¦ì¤j¤j¦n,¤p§Ì¤£¤~
·j´M¤F¤j¬ù¤Q²ÕªºGAMIL CODE ¥þ³¡³£µLªk±H«H,·|¥X²{¬Û¦Pªº¿ù»~

¤£¾å±o¬O¬Æ»ò°ÝÃD
·Q½Ð±Ð¤j¤j­Ì¨â­Ó³¡¤À
¤@:¦p¦ó¥¿½T±H¥X«H¥ó
¤G:¦³¿ìªk¹wÄý«H¥ó¤£±H¥X¶Ü?
  1. Sub send_email_via_Gmail()
  2. Dim myMail As CDO.Message

  3. Set myMail = New CDO.Message

  4. myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True

  5. myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1

  6. myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"

  7. myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

  8. myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

  9. myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "[email protected]"

  10. myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "your_password"

  11. myMail.Configuration.Fields.Update

  12. With myMail
  13. .Subject = "Test Email from Dr. Takyar"
  14. .From = "[email protected]"
  15. .To = "receipt"
  16. .CC = ""
  17. .BCC = ""
  18. .TextBody = "Good morning!"
  19. '.AddAttachment "C:\Users\takyar\Desktop\email-via-gmail.txt"
  20. End With
  21. myMail.Send
  22. Set myMail = Nothing

  23. End Sub
½Æ»s¥N½X
PKKO

¦^´_ 2# ML089

ª©¥D¤j¤j±z¦n,§Ú³£¦³¿é¤J§Ú¹ê»Úªº¸ê®Æ®@!¦ý¤´µM¥X²{¹Ï¤ù¤¤ªº¿ù»~,©Ò¥H¤~po¤å¨D±Ï
µ{¦¡½X¸Ì­±¬O§Ú¤w¸g­×§ï¹Lªº,²¦³º¤£¯à§â§Úªº¯u¹êmail±K½X³£¶K¥X¨Ó= =
½Ð°Ýª©¥D¤j¤j¥Î¦¹code¥i¥H±H¥X«H¥ó¶Ü?ÁÙ¬O¦³­þ¤@­Ócode¥i¥H±H¥X«H¥ó?
PKKO

TOP

¦^´_ 4# imingho

·PÁ¤j¤j¨ó§U¥i¥H±H«H¤F
­ì¨Ó¬O³o¼Ë
PKKO

TOP

½Ð°Ý¦³¤j¤j­Ìª¾¹DGMAIL¦p¦ó¥i¥H¹wÄý«H¥ó¦Ó¤£±H¥X¶Ü?
¹³OUTLOOK
¥i¥H¥Î.Display '¹wÄý«H¥ó
PKKO

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD