+ Reply to Thread
Results 1 to 3 of 3

Sending email via gmail error

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    118

    Sending email via gmail error

    Hello there, i have a code that sends the current workbook and some other files by email with Gmail.

    The code is working fine as i tested it at home, but as soon i tried it in my company it gives the error about not able to connect to the internet.

    Is there something i can do to force connection or something?

    Really appreciate your help.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Sending email via gmail error

    Hi, any chance you can upload the actual spreadsheet which will have all the code as well as a visual clue as to the data / process.

    Uploading the actual worksheet (remember to desensitivise and confidential data) will almost always get you a faster response from the forum

    cheers

    Cheers

    Jmac1947

    1. Please consider clicking on the * Add Reputation if you think this post has helped you
    2. Mark your thread as SOLVED when question is resolved

  3. #3
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    118
    Hello and thank you for the suggestion,
    But the workbook is almost 5mb and full of data of my companie, names, revenues, locations etc.

    Its will be a pain to edit all that data and be able to reduce the size to be able to upload would take me ages.

    The problem persist in this module. When I try to run it connected at my home network it runs perfectly but when I try to run it on my companie network it just can't connect.

    This module just export one worksheet as pdf and another as a copy os the current workbook and tries to send them by gmail.

    Maybe later this evening I can try to create a exemple workbook and upload it here.
    Last edited by jeffreybrown; 03-28-2019 at 12:24 PM. Reason: Removed quote!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sending Email via gmail with current workbook as attachment
    By Tpleme in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2019, 01:31 AM
  2. [SOLVED] Error message when sending attachment by Gmail
    By hadleedog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2019, 11:10 PM
  3. VBA to use excel for sending multiple attachementi through gmail
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2018, 03:08 PM
  4. Sending Emails via Excel VBA using GMAIL SMTP Server - ERROR MESSAGE HELP!!!
    By beasley101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2015, 09:47 AM
  5. [SOLVED] Sending to gmail through VBA
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2014, 05:13 PM
  6. [SOLVED] Sending to gmail through VBA
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2014, 09:46 AM
  7. Sending email using Gmail and attaching workbook.
    By vitt4300 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2012, 02:28 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1