Send email from excel using VBA. Peter Kirklewski, Senior VBA programmer. tel: 0048787950948 in EU or 0013157794406 in NY.
Video Rating: 4 / 5
Oct
29
Send email from excel using VBA
Valley Forge Mailboxes Blog, Valley Forge PA
Mail Forwarding, Mailbox Rental and Ebay selling servces
23 comments
No ping yet
Makattack707 says:
October 29, 2012 at 5:07 pm (UTC 0)
I love the simple way you explained, wow Thanks for the info, and your time..10 stars
zinedinezidanezizou says:
October 29, 2012 at 5:37 pm (UTC 0)
Same doubt here.
Maybe the guy won`t see this, but can anyone else help us, please?
fallencmd says:
October 29, 2012 at 6:03 pm (UTC 0)
Nice Video, killer accent !
Is it possible that instead of a file being attached it would display the content of some cells within the workbook on the email? Thanks
Abdeen2012 says:
October 29, 2012 at 6:35 pm (UTC 0)
i have a little problem here, every time it gives me compile error : label not defined and highlight on Public Function sendemail()
Yaniv Ofer says:
October 29, 2012 at 7:27 pm (UTC 0)
Hi,
thank you for your time creating this helper!
Is there any option that you will upload a guide how to send rows from excel via Gmail or Outlook?
every time I push the button I want that to send rows that I choose to email address that I enter.
mytubeslb says:
October 29, 2012 at 7:46 pm (UTC 0)
will it work if in the ebody i make a paste of eg a range selected and copied from excel? or does the ebody only allows for strings?
ITBroom says:
October 29, 2012 at 7:55 pm (UTC 0)
This is a nice clear video. You demonstrate the structure well enough that I can see how I can use the variables to send different worksheets to different people. Thanks for this!
MoaZZam Muzzammil says:
October 29, 2012 at 8:05 pm (UTC 0)
I am trying to do the same thing with word but the email software I like to launch is IBM Lotus Notes after clicking the Send email button. How can I modify the program in this tutorial to launch Lotus notes?
thecorn92 says:
October 29, 2012 at 8:40 pm (UTC 0)
I fucking Love you, you dont know how long iv been trying to this!!!!
purenrg4life says:
October 29, 2012 at 9:17 pm (UTC 0)
Thank you!
danielkhemri says:
October 29, 2012 at 10:07 pm (UTC 0)
Could it be possible to have the email to send to be the properties of an inputbox? And if so, how could one go about doing so? Thank you in advance!
Fantastic tutorial!
carlosmedinajr says:
October 29, 2012 at 10:59 pm (UTC 0)
How would you add mulitple command boxes with the same email function. I want to create an excel sheet that works a work flow routing form.
FreeExcelFormulas says:
October 29, 2012 at 11:27 pm (UTC 0)
it turns out, Excel can do that, it looks like I have much to learn
RandyKelly19 says:
October 29, 2012 at 11:28 pm (UTC 0)
I got 2007; Originally it worked now it says function not defined pointing to Public Function sendmail()
Any suggestions?
vnb10kke says:
October 29, 2012 at 11:44 pm (UTC 0)
I tried in Excel 2003,It is not working,
Wolf Peddinghaus says:
October 30, 2012 at 12:39 am (UTC 0)
Pretty cool! If you have any more excel/vba tutorials with email functionality, keep ‘em coming! Thanks!
sabryluv says:
October 30, 2012 at 1:33 am (UTC 0)
Send by this code, some .doc or .xls document?
nagileon says:
October 30, 2012 at 1:54 am (UTC 0)
What kind of document ?
sabryluv says:
October 30, 2012 at 2:38 am (UTC 0)
Can we do that with all kind of document? For me, it’s only work with .csv file! Is it normal?
kingdavid3 says:
October 30, 2012 at 2:49 am (UTC 0)
Your English is not rubbish..you really can communicate it to newbies like me great…Fantastic piece of tutorial!
Felipe Cardoso says:
October 30, 2012 at 3:35 am (UTC 0)
Very Nice!!!
Panta2324 says:
October 30, 2012 at 3:35 am (UTC 0)
nice tutorial:)
csibond says:
October 30, 2012 at 3:54 am (UTC 0)
great tutorial… hope you could make a lot of tutorials..thanks a lot…