Consulting

Results 1 to 6 of 6

Thread: Open Gmail

  1. #1
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location

    Open Gmail

    Is there a way to add vba that will open my gmail account?

    I use Chrome which is my default browser. Then I use gmail which is my default email.
    I have code that is already attached to a button on screen. It creates a pdf file and puts it into a directory. I would love right after that to open and go to my email. I can enter manually the email address, the attachment, subject, etc etc. unless this is feasible with online mail.


    Thank You in advance.
    Michael Daniels

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    I don't use it myself. If you have Access, view the VBA code in Access at this site to see how to do it. http://www.vbatutorial.org/access-vb...rom-access-vba

  3. #3
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    I dont have access. Any other ideas?

    Mcihael

  4. #4
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    You want to open your browser and go to your email account? Or do you want to send via your gmail account right away? If the latter, check out these links...

    http://www.ozgrid.com/forum/showthre...t=84628&page=1
    http://www.access-programmers.co.uk/...d.php?t=205388
    http://www.rondebruin.nl/cdo.htm

  5. #5
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    I know you responded to this way back, but I need to open my gmail.
    I have a button I hit now and it saves the active excel sheet as a pdf. I then need to open my gmail account.
    Then I can manually attach the pdf file I just created.

    Michael D

  6. #6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •