Тэги:
#How_to_send_email_using_Gmail_via_Excel_VBA #send_email_via_gmail_automatically #send_mail_with_Excel_VBA_using_CDO #Collaboration_Data_Objects_VBAКомментарии:
Is it possible to add a JPG to the bottom of the email you have created.
Ответитьsend a coding as a text file
Ответитьthx
ОтветитьSir, one clarification
ОтветитьDear Sir,,
Big fan of u..😇 ..I need to insert the PNG or JPG snap file into the GMAIL BODY of the Content. Like after "Hi Team,"<PNG File pasted >.......Can u plz tell me that how to insert into the gmail body?..
I am getting as a empty mail only..I am using send keys and object and Range HTML also..But no uses...!!!
Thankyou Dinesh
ОтветитьSir, Can I have the code to pick up, email address and attachment from Excel Table Active Row 👍 Thank you in advance.👍
ОтветитьDear Mr Dinesh Kumar Takyar
Best wish for you during this pandemic
i want to ask you a question, because i already copy all your code, run it Ok but gmail did not send anything. I also turn off the security, so could you please show me what happen
Thank you very much
Thank you Daniesh for the helpful video.
ОтветитьSIR I AM GETTING RUNTIME ERROR ON SUBJECT TELL ME THE SLOUTION PLEASE
ОтветитьNameste Sir,
Can we schedule every mail in Gmail
And can we paste image in email body
Thanks in advance
No error observed while running and no email sent. Please help
ОтветитьGreat
ОтветитьDear Takyar Ji, Jai Hind ! I am getting error message at " The "SendUsing" configration value is invalid
How to resolve it ?
Sir, my file has some vba Macros, and about 5 work sheets, i only want a single file to be sent via gmail, what is the procedure sir,
ОтветитьHi ,
How to send email automatically by fetching the records from Excel sheet and sent them bday wishes . Right now you have given hard coded email id
Hi Sir, whether we can send multiple bulk emails with different contain based on value in excel. I want to send through Gmail only.
ОтветитьHi Im trying to list the numbers of a sequence of intervals
A1 will have (13456666-13456668) and I should get the below in
A2 (13456666,13456667,13456668)
I cant get going with this, any help with automating this is appreciated
Sir how I can send multiple people and different attachment can it possible?
ОтветитьThank you for posting this. It is half of what I am trying to do. Is it possible to do a mail merge using Gmail with this ?
ОтветитьDoes it take some time to send/receive the email? I sent it and got the success message as well, but I do not see the email in my Gmail inbox.
ОтветитьCan i use this concept with Mail becky application?
ОтветитьVery helpful. Thanks! I would very much be interested to implement something like this, but with multiple emails with an Excel file that contains columns with all sort of data. The emails are included in the Excel file, so it would be a row per recipient. Do you have a video for something like that?
ОтветитьHello Mr Dinesh Sir, You are my Teacher like "eklavya Guriji" for All of your Tutorials Thank you very very very much for all of your tutorial, This is really work fine
ОтветитьHi Dinesh. I'm using an automated Excel Invoice, where i want to send email by clicking a button, and it send email through gmail to the client. When i click the send email button, Each time the Macro should capture email id from a cell in the excel invoice. I have already created a Macro for saving as PDF. PDF invoice should automatically be attached to the email. Subject will be the filename of the invoice. Anyway to do this?.
ОтветитьHello Sir, thanks for the guidance, It's easy to understand and implement. I am stuck with one thing, so need your help if possible. I can't restrict my mail body content within certain cells, it might vary depending on the email. Hence earlier i used to send multiple emails using macro via Outlook in Excel itself, but now need to use gmail. In Outlook, mail body used to be my selection of cells in excel. I am unable to do it in Gmail. In short, Activesheet.selection needs to be my Email Body in Gmail. Kindly help. Thank you.
ОтветитьDear Sir,
I have a lisbox filled with data ( many lines and some columns ) and i wand to send all data in listox via email. would you please assist me to do that ?
best regards
I would like to display the email before sending. Please indicate how this can be done? I have looked at the reply below but can't find the answer in the link you gave. Thanks
ОтветитьHi Sir ...Excel cha code for sending mails via gmail along with attachment file.. please aap iska video banao...
ОтветитьThank you very much; It took me 5 mins to copy your code and integrate this within my application, This is the best piece of code I have seen for a bit. You also explained it with such clarity, Greetings from London, UK Edward
ОтветитьThank You Sir. It worked perfectly...
ОтветитьI have 2 questions:
1. How to display email before sending it ? It is important as I want to make adjustments and then click "send".
2. How to attach current open excel from which macro is written and which does not need to be saved after being emailed?
Sir I have tried this programme and it is working perfectly . I want to add this code with a n excel Invoice vba which goes like this "Sheet1.Range("A2:R27").ExportAsFixedFormat xlTypePDF, Filename:= _
"C:\Billing Data\new_sale_invoice" " so that my invoice should be converted into pdf as well as mailed via gmail. Would you help me please.
Will this work in Word 2016 for all clients email ?
ОтветитьSir, Can we send mail by uninstalling outlook in system
ОтветитьWorks great. Is there anyway to get a reference of cells to be the To and from, so if the addresses change you can a cell instead of modifying the script?
ОтветитьHi sir. thx for the tutorial.. it works .. but I have some problem, I want to send excel sheet an cell as the body of email not as the attachment.. can u help me solve this problem and show me the code? I've tried some code but it only works for outlook... I need the code to send it with CDO message.. can u solve this? thx
ОтветитьHello Sir. I need your support on my below doubt. In my Company they using gmail application as front end for Sending/Receiving emails but backside it is running in our company server. I just trying to create a macro for sending automatic email with my company SMPT name and port number but i am not able to send mail using this and also advise should i give my password in code because my username already having access to connect with our server . Could you please support me on this.
ОтветитьReally usefull sir
ОтветитьHello... This is great dialogue. Could someone recommend how to embed a longer Mail.TextBody where VBA can update certain verbiage as it loops though the multiple Mail.To's . The video has a simple one liner, but I want to have many more (up to 20) Mail.TextBody lines, include closing salutation. PLEASE HELP ME
ОтветитьThis doesn't work for 2016 Office for the Mac Right?
Ответитьhi, I would like to attach the last date modified file (automatically), how can I do that? thank in advance!!
Ответитьdo u know how to run macro automatcally when data entered cell?
Ответитьshould i activate outlook in my pc? bcs the code vwasn't working... there s no email sent in my gmail...
Ответитьhi, i am just not able to send mail using this, i tried everything but its not working, the code runs and doesnt display any error but in email i dont see any send or received mail, when i remove "on error resume next" line from code then it gives error " the transport failed to connect to the server" plz help
ОтветитьThe smtp port should be 465
Ответитьhi Dinesh,
thank you for your wonderful tutorial. the code was working fantastic.but, is there a way where i can set the bounce back mail to my email id when the mail is not delivered. if that can be incorporated. the code is just great. right now i am not getting bounce back mails.
will be waiting your reply
thanks and regards
kishore
Hello Mr Dinesh, You are my Hero :D, Thank you very much for all of your tutorial, This is really works.
Ответить