A few of you are asking about sending your invoice via gmail rather than outlook. This is possible - please see this excellent article wellsr.com/vba/2020/excel/vba-send-email-with-gmail/
So i have read the article and using your template, I was still not able to use my gmail vs outlook. I'm not sure what I'm doing wrong in the macros for it not to work.
I get an error message saying that I don't have an internet connection which I do. What could be the problem on my end? Edit. I fixed the internet issue but get a transport to server error. I triple checked my code and the code is good,
there is one single issue you did not cover in the whole part. How to remove objects when save to pdf and because logo is an object, macro will delete it when clicked on save as pdf
@@indianyoutube9749 (covered in Q&A on Video #3) "****If you are having trouble with your logo being deleted use this code:**** For Each shp In ActiveSheet.Shapes If shp.Type msoPicture Then shp.Delete Next shp Hope this helps 👍
A thousand thanks for providing us with this gem of a series. i will also add my small contribution by sharing what i found. For anybody who like me was looking for a way to add a line break to the email body, you can use the special character sequence 'vbCrLf'. You can also double it or more to increase the space between the lines. For example : .Body = "Hello," & vbCrLf & "Please find attached the document mentioned above." & vbCrLf & vbCrLf & "Best regards." Hope it works for everybody
Thank you so much for all of the information you post. You make life so much more convenience and efficient. My only question regarding this tutorial would be: how can we direct the email to be sent from a specific email? I have several accounts and it doesn't send from the default account. I do look forward to hearing from you. Thanks in advance.
If you are having trouble with your logo being deleted use this code: For Each shp In ActiveSheet.Shapes If shp.Type msoPicture Then shp.Delete Next shp
I have been looking for ages for a way to attach e mail to invoices, this is really helpful and it works!!! Thank you for your Professional contribution.
Hi Chester these tutorials were awesome thank you so much. I have a question Will you be doing a tutorial for an end of month statement to go with this?
This has been the best tutorial on making invoices I have seen. My only issue I have come across is that I don't have Outlook. I have my own domain name and G-mail. Can anyone please help me make this Macro for G-mail. I appreciate it. Thank you and you Chester for all you've done.
Thanks so much for all your efforts! This method works even better than some professional softwares in my situation as I can custom and change functions the way I want! Good Job!!
Thank you for this series, you have truly helped me develop an invoice system. I have added features, like to not recording duplicates and ensuring that all important fields are entered before recording or saving the invoice. Something were a bit tough, especially as a mac use, but I managed to make it work accordingly.
Hi there. This is the only macro I haven't been able to get up and running on my mac. Were you able to get this functioning by following the code exactly? Looking for a work around active-x
Greetings! Let me start by saying thank you for the amazing series. Great explanation and easy to follow along. I got a question. If I wanted to personalized the email body with a greeting to the client and display the client's name with the variable set for it. How would one go about that if possible. Thanks anticipated for your time.
Thank you very much for this extremely helpful series of videos. I have been creating a TimeSheet - Invoice workbook for my partner and found your tips and code easy to follow and tailor to her requirements. I added a message box which pops-up to confirm the execution of the VBA to Export and Email the PDF. I wish to add a secondary Message Box which asks the user if they wish to send the email right away or open for checking & editing (thus, making the .Display or .Send line a variable) but so far I am unable to find how to a/ Have custom text in message box response buttons, b/ use a message box answer to change the code between .Display and .Send. Will persevere.
I truly appreciate your teachings and your tools. This tool is perfect for my small business. I was watching you vidoes and planning to create one from scratch, but then I was wondering if you would be willing to sell a copy of the workbook? I would have to do some customizing but it would save me a lot of time. If you would be interested in selling me a copy please let me know how much.
Hello thanks for these helpful videos. I am running into an issue with this part.. Set EApp = CreateObject("Outlook.Application") Would it possibly be because I am using a Mac? Is there any way around this? Thanks for your help
@@maggiegonzalez8059 I tried using Mozilla Thunderbird. But after reacearch, only Gmail and Outlook are good for this. So I suggest installing Outlook, logging in with ANY email account and running answers back to another email you want. (its a setting in outlook)
I've learned a lot by watching this series of VBA videos, thank you. Like a lot of others, I do not use outlook. I use Mozilla Thunderbird as my email client. Could you tell me what I need to change to send the invoice from Thunderbird?
These videos are excellent. Was wondering, once the pdf is created and it is posted to the record of invoices, is there a way to regenerate the invoice to mark it as paid and send the receipt by email?
Thank you so much, Chester. I have been following along and I love your videos. I had to make a few teaks along the way with my MacBook. I would love to enable the email function, but I am using MacBooks Mail rather than outlook. I am getting a bug under SetApp, and I am not entirely sure what to write. Any chance you know what I should replace SetEApp = CreateObject("Outlook.Application") when using MacBook mail?
I'm currently looking at this. It appears that those lines of code use a few things that our MacBooks don't have which is access to an opensource software called active-x. In my case I am also missing a crucial reference as an option as well. I really want this feature so I'll be digging for a work around. Part of me wants to believe that I should have downloaded a windows emulator from the get-go and installed the windows version of excel there. Cross-platform programs are usually almost always better on the native OS that they were created on it seems. Anybody find a workaround for this?
The only issue I see is in the tax (VAT) area. You are only calculating tax revenue @20% for 1 item. So if I have 50 items at $5.00 it only charges 1.00 tax. Could you please help with a formula that would correct this? I tried to figure it out on my own but have failed.
Please disregard my last reply. I figured it out. The formula that you used was =IF(F19"",G19*20%,"") which gave you 20% times a quantity of one item dollar amount. The new formula is =IF(F19"",I19*20%"") this will give you tax amount in total quantity dollar amount.
Thanks, excellent tutorials so handy and well created. A similar sort for cash books would be fantastic as well even better if invoices and spending all linked
@@ChesterTugwell I want to learn how to create my own cash book system so to monitor finances but with your excellent invoice worked into it to automatically add the finances when setting paid to yes would be great as it takes ages going over the paperwork even on software.
Hi Chester, these videos were unbelievably helpful, thank you for taking the time to put them together! As many others have asked, I'm looking to use this same approach using Gmail vs Outlook. Any insights on how to change the VBA to do this?
Thank you very much. How can I make it work on Mac it everything work good only the email is not working even if I install outlook error ActiveX component can't create object, Can you help me with this? Thanks in advance
Chester I love these videos. I was following the invoice tracker this morning and followed the code for the VBA, but when I ran the module, I saved the details in the invoice part of the workbook rather than the tracker. Did i miss something?
cheers for your help , very good. the only problem i cant get around is the following: i get a debug error saying runtime error "287" application - defined or object defined error?? any ways to fix this?
Hello Chester, Your video series is amazing. The only problem came with the email portion. When I try to email the pdf I get a run time error 429 - ActiveX component can't create object at Set EApp = CreateObject("Outlook.Application") can you please help
I seem to encounter a problem with ( .To). So on a single cell the Range is ("C11") or on a merged cell is ("C11:H11"). In both cases, when hovering over the highlighted area, it shows the email address. I am confused...
Is it possible to get the VBA button options with the assigned micro in a drop down menu so that one can choose and select whether to say export as pdf or xls?
How do you go back to viewing a previous invoice that was already created aside from record of invoice. For example if you had to make a change to an existing invoice
May I ask what operating system and version you are demonstrating on pls, I get so far to finishing but I do not display the same options as you do for creating “new formatting Rule” as you do....I have the latest version on my Mac and office 365?
Hi Chester, Thank you for making this Vlog, it has been extremely helpful. I am a novice at excel and your instructions are extremely helpful. When I click on the button to save the file to excel or PDF, instead of the customer's name displayed in my saved file it only shows the "Cell" Name; ie PDF 200 _ B10.pdf. this is also the same for the other save buttons. How do I change it to the actual customer's name in the VBA? Regards, Alistair
Dear Mr. Tugwell, I've followed every step of your video and I've check my scrip is 100% same as yours. Anyway, it cannot send the PDF file via email when I run the marco. It displays only desipte I have amended "Display" to "Send". Please kindly let me know what did I missed or made mistake ? Thank you very much.
I’ve found that if the customer table doesn’t have all sections filled in about a customer they show up on the invoice as zeroes instead as blank like it does when no customer is selected and your method to remove the N/A. How do I resolve this issue ? Thanks
can you please guide me how to save invoice contents like product description with its price on separate sheet ?? so i can easily search product price billed before
Hi Chester, these videos are amazing and I have so enjoyed creating my invoices along with the videos, thank you so much for sharing. I was just wondering if there is a way that all the Record of Invoices boxes can be filled in with one button, so that all the invoice info, Invoice saved as PDF, Invoice saved as excel file and invoice emailed date, are done in one go, Thank you again for the information and videos
Thank you for the Reply, do you have a video showing how to set up calling for a macro name, and is it possible to change the path lines to save on OneDrive.
I really like this idea and the functionality behind it. However, I am having issues getting the macros to work. (I am positive it is my own lack of knowledge). I can't seem to get the "Save as .xlsx", "Save as pdf", or "Email as pdf" buttons to work. If anyone is willing to help me get this set up, I would be extremely grateful.
Mr. Chester, My name is Rosie. I have a problem with this macro. When I tried running it, my malwarebytes blocked it. It detected an exploit and I couldnt run the macro
Mr. Chester, when I push the macro buttons to record in my record of invoice sheet. It records the invoice, but it creates a new line for each macro I push. It doesn't put all the information for each macro on one line. Can you please help?
Hey mate. Amazing teaching. I have one question. I want to basically convert this template into a receipt and so where you have 'term 30,60,90' I have put 'Paid' into that list. This works for everything else, except when I try to email it it says 'mismatch' the debugger sends me to the VBA sub and highlights where term should be a number but mine says Paid. It's really not liking this, how do I fix?
hi mr chester. thanks a lot for your tutorial video. it really help me a lot. just asking can u help me with tutorial on how to attach pdf file and send via whatsapp desktop. currently i manage to open the exe app using syntax Shell ("C:\TEST\whatsApp.exe") but got no idea on how to attach the file like what you did on this email tutorial. really hope u can help me with this. thanks a lot sir
I created my own bulk invoicer for my business by watching this 6 videos. I got a trouble at last step which is making the EApp defining and object creation. There is a error cord debugging this Epp object creating. Please kindly help me.
Have loved this series/playlist, but have run into a snafu that doesn't seem to have an answer in the comments...how to send the pdf if it's going to be used on a Mac? I'm assuming the code is different and is probably also running into the walls of the sandboxing?
Goede avond. ben bezig met email pdf ik gebruik gmail. hoe kan ik de vba code aanpassen? met Set Eapp = CreateObject("Outlook.Applcation") lukt het niet. Heb ook op de link gekeken maar daar kan ik geen wijs uit worden. Ik zie u antwoord graag tegemoet
I love this videos but I am in dire need of help pleaseee! I am using a Mac book so I decided to use the mail application instead of outlook. I am using the code below but the pdf is not attaching to the email. I am not sure what I am doing wrong Sub SaveAsPdfAndSendEmail()
applescriptCode = applescriptCode & "make new to recipient at end of to recipients with properties {address:""" & Sheets("Invoice for Printing").Range("B12").Value & """}" & vbNewLine
A few of you are asking about sending your invoice via gmail rather than outlook. This is possible - please see this excellent article wellsr.com/vba/2020/excel/vba-send-email-with-gmail/
Hi And for apple mail? is it possible?
So i have read the article and using your template, I was still not able to use my gmail vs outlook. I'm not sure what I'm doing wrong in the macros for it not to work.
I get an error message saying that I don't have an internet connection which I do. What could be the problem on my end?
Edit. I fixed the internet issue but get a transport to server error. I triple checked my code and the code is good,
there is one single issue you did not cover in the whole part. How to remove objects when save to pdf and because logo is an object, macro will delete it when clicked on save as pdf
@@indianyoutube9749 (covered in Q&A on Video #3)
"****If you are having trouble with your logo being deleted use this code:****
For Each shp In ActiveSheet.Shapes
If shp.Type msoPicture Then shp.Delete
Next shp
Hope this helps 👍
A thousand thanks for providing us with this gem of a series. i will also add my small contribution by sharing what i found. For anybody who like me was looking for a way to add a line break to the email body, you can use the special character sequence 'vbCrLf'.
You can also double it or more to increase the space between the lines.
For example :
.Body = "Hello," & vbCrLf & "Please find attached the document mentioned above." & vbCrLf & vbCrLf & "Best regards."
Hope it works for everybody
Simply amazing and so easy to follow. Thank you so much for your excellent method of teaching VBA.👍
Thank you so much for all of the information you post. You make life so much more convenience and efficient. My only question regarding this tutorial would be: how can we direct the email to be sent from a specific email? I have several accounts and it doesn't send from the default account. I do look forward to hearing from you. Thanks in advance.
You've saved me a lot of hours.
If you are having trouble with your logo being deleted use this code:
For Each shp In ActiveSheet.Shapes
If shp.Type msoPicture Then shp.Delete
Next shp
Thanks a lot!
What a brilliant series. Really well worked out and narrated. Thank you.
Easy, short and straight to the point
I have been looking for ages for a way to attach e mail to invoices, this is really helpful and it works!!! Thank you for your Professional contribution.
Glad it was helpful!
Great course. Perfect for my small business. Easily understandable method of explaining/teaching. 🎖
Thank you very much sir, your lesson was of great benefit to me... Thanks again. i'm from Sri Lanka
Thank you for the great videos, this worked perfectly for my invoicing.
Hi Chester these tutorials were awesome thank you so much.
I have a question
Will you be doing a tutorial for an end of month statement to go with this?
Thank you
Mr. Chester,
this video is helped me a lot to sort out my excel sheet and auto mail issue
Amazing instructions from video 1 to 6! Thank you for your help 😊
This has been the best tutorial on making invoices I have seen. My only issue I have come across is that I don't have Outlook. I have my own domain name and G-mail. Can anyone please help me make this Macro for G-mail. I appreciate it. Thank you and you Chester for all you've done.
Please see wellsr.com/vba/2020/excel/vba-send-email-with-gmail/
Thanks so much for all your efforts! This method works even better than some professional softwares in my situation as I can custom and change functions the way I want! Good Job!!
Thank you for this series, you have truly helped me develop an invoice system. I have added features, like to not recording duplicates and ensuring that all important fields are entered before recording or saving the invoice. Something were a bit tough, especially as a mac use, but I managed to make it work accordingly.
I really want to thank you for your videos. They are awesome! I appreciate it. I was able to apply this to Excel on my Mac.
Hi there. This is the only macro I haven't been able to get up and running on my mac. Were you able to get this functioning by following the code exactly? Looking for a work around active-x
This whole Series was super helpful!
Thank you so much :D xx
Your an excellent teacher. Thank you!!
Thanks for your time. That was very insightful.
Thanks so much! Very easy to follow along
Amazing and helpful content, I have actually created my own out of this series of video
Excellent series, thank you so much!!
Greetings! Let me start by saying thank you for the amazing series. Great explanation and easy to follow along. I got a question. If I wanted to personalized the email body with a greeting to the client and display the client's name with the variable set for it. How would one go about that if possible. Thanks anticipated for your time.
Thank you very much for this extremely helpful series of videos. I have been creating a TimeSheet - Invoice workbook for my partner and found your tips and code easy to follow and tailor to her requirements. I added a message box which pops-up to confirm the execution of the VBA to Export and Email the PDF. I wish to add a secondary Message Box which asks the user if they wish to send the email right away or open for checking & editing (thus, making the .Display or .Send line a variable) but so far I am unable to find how to a/ Have custom text in message box response buttons, b/ use a message box answer to change the code between .Display and .Send. Will persevere.
I truly appreciate your teachings and your tools. This tool is perfect for my small business. I was watching you vidoes and planning to create one from scratch, but then I was wondering if you would be willing to sell a copy of the workbook? I would have to do some customizing but it would save me a lot of time. If you would be interested in selling me a copy please let me know how much.
Hello thanks for these helpful videos. I am running into an issue with this part..
Set EApp = CreateObject("Outlook.Application")
Would it possibly be because I am using a Mac? Is there any way around this?
Thanks for your help
What if I dont have outlook? how do I modify it for other email applications?
@@maggiegonzalez8059 I tried using Mozilla Thunderbird. But after reacearch, only Gmail and Outlook are good for this. So I suggest installing Outlook, logging in with ANY email account and running answers back to another email you want. (its a setting in outlook)
I've learned a lot by watching this series of VBA videos, thank you. Like a lot of others, I do not use outlook. I use Mozilla Thunderbird as my email client. Could you tell me what I need to change to send the invoice from Thunderbird?
any luck in adaptating the code for Thunderbird? Thanks!
These videos are excellent. Was wondering, once the pdf is created and it is posted to the record of invoices, is there a way to regenerate the invoice to mark it as paid and send the receipt by email?
Thank you so much, Chester. I have been following along and I love your videos. I had to make a few teaks along the way with my MacBook. I would love to enable the email function, but I am using MacBooks Mail rather than outlook. I am getting a bug under SetApp, and I am not entirely sure what to write. Any chance you know what I should replace SetEApp = CreateObject("Outlook.Application") when using MacBook mail?
Having the same issue here. Could you fix it?
@@nicodem4rco me too facing same issue
Same here! Did you guys found a solution for this? If so please let me know.
I'm currently looking at this. It appears that those lines of code use a few things that our MacBooks don't have which is access to an opensource software called active-x. In my case I am also missing a crucial reference as an option as well. I really want this feature so I'll be digging for a work around.
Part of me wants to believe that I should have downloaded a windows emulator from the get-go and installed the windows version of excel there. Cross-platform programs are usually almost always better on the native OS that they were created on it seems.
Anybody find a workaround for this?
Amazing job! Thank you so much for sharing your knowledge with us!
The only issue I see is in the tax (VAT) area. You are only calculating tax revenue @20% for 1 item. So if I have 50 items at $5.00 it only charges 1.00 tax. Could you please help with a formula that would correct this? I tried to figure it out on my own but have failed.
Please disregard my last reply. I figured it out. The formula that you used was =IF(F19"",G19*20%,"") which gave you 20% times a quantity of one item dollar amount. The new formula is =IF(F19"",I19*20%"") this will give you tax amount in total quantity dollar amount.
Thanks, excellent tutorials so handy and well created.
A similar sort for cash books would be fantastic as well even better if invoices and spending all linked
Great suggestion!
@@ChesterTugwell
I want to learn how to create my own cash book system so to monitor finances but with your excellent invoice worked into it to automatically add the finances when setting paid to yes would be great as it takes ages going over the paperwork even on software.
you are making my life soo much easier now thx! do u know if its possible to mail from apple mail (working on a macbook )
Hi Chester, these videos were unbelievably helpful, thank you for taking the time to put them together! As many others have asked, I'm looking to use this same approach using Gmail vs Outlook. Any insights on how to change the VBA to do this?
Paulina, please see wellsr.com/vba/2020/excel/vba-send-email-with-gmail/
Thank you very much. How can I make it work on Mac it everything work good only the email is not working even if I install outlook error ActiveX component can't create object, Can you help me with this? Thanks in advance
Having the same issue. Could you fix it?
Chester I love these videos. I was following the invoice tracker this morning and followed the code for the VBA, but when I ran the module, I saved the details in the invoice part of the workbook rather than the tracker. Did i miss something?
Thanks Chester!
Would you maybe be able to show me how to add the signature to this code?
Thanks again. Really helpful and easy to follow! :-)
cheers for your help , very good. the only problem i cant get around is the following: i get a debug error saying runtime error "287" application - defined or object defined error?? any ways to fix this?
Thanks for the awesome content. What if I am not using Outlook as my email app? I use Proton Mail.
Hello Chester,
Your video series is amazing. The only problem came with the email portion.
When I try to email the pdf I get a run time error 429 - ActiveX component can't create object at
Set EApp = CreateObject("Outlook.Application")
can you please help
On running the macro I get Run-time error ‘429’:
ActiveX component can’t create object
What about the duplicate records in the list since if you send to both pdf and save as xlsx file, it creates two rows?
Thank u man..u are awesome 👏
I seem to encounter a problem with ( .To). So on a single cell the Range is ("C11") or on a merged cell is ("C11:H11"). In both cases, when hovering over the highlighted area, it shows the email address. I am confused...
Is it possible to get the VBA button options with the assigned micro in a drop down menu so that one can choose and select whether to say export as pdf or xls?
Amazing, but my question is that, there is no opion to open gmail dialog box in excel and reply to given user.
Any trick with VBA OR NOT
How do you go back to viewing a previous invoice that was already created aside from record of invoice. For example if you had to make a change to an existing invoice
Hi Thanks for this, is there any way to make it so it included my email signature when it generates the email in outlook? Thanks
May I ask what operating system and version you are demonstrating on pls, I get so far to finishing but I do not display the same options as you do for creating “new formatting Rule” as you do....I have the latest version on my Mac and office 365?
Hi Chester, Thank you for making this Vlog, it has been extremely helpful. I am a novice at excel and your instructions are extremely helpful. When I click on the button to save the file to excel or PDF, instead of the customer's name displayed in my saved file it only shows the "Cell" Name; ie PDF 200 _ B10.pdf. this is also the same for the other save buttons. How do I change it to the actual customer's name in the VBA? Regards, Alistair
Dear Mr. Tugwell, I've followed every step of your video and I've check my scrip is 100% same as yours. Anyway, it cannot send the PDF file via email when I run the marco. It displays only desipte I have amended "Display" to "Send". Please kindly let me know what did I missed or made mistake ? Thank you very much.
Well done sir, do you have vba code for monthly reports balance sheet sending as pdf to email from excel?
I’ve found that if the customer table doesn’t have all sections filled in about a customer they show up on the invoice as zeroes instead as blank like it does when no customer is selected and your method to remove the N/A. How do I resolve this issue ?
Thanks
can you please guide me how to save invoice contents like product description with its price on separate sheet ?? so i can easily search product price billed before
How to send the mail selectively in a distribution list based on checkbox selection? Also how to zip the file as an attachment and mail via Outlook.
Thanks Chester!
Is there anyway to get my custom signature block from outlook to display?
Amazing
thank you so much
Hi Chester, these videos are amazing and I have so enjoyed creating my invoices along with the videos, thank you so much for sharing. I was just wondering if there is a way that all the Record of Invoices boxes can be filled in with one button, so that all the invoice info, Invoice saved as PDF, Invoice saved as excel file and invoice emailed date, are done in one go, Thank you again for the information and videos
Hi. Thanks. You could create another macro that called each macro in turn. Eg Call Macro Name
Thank you for the Reply, do you have a video showing how to set up calling for a macro name, and is it possible to change the path lines to save on OneDrive.
Can you show us how to do this?
@@ChesterTugwell
I really like this idea and the functionality behind it. However, I am having issues getting the macros to work. (I am positive it is my own lack of knowledge). I can't seem to get the "Save as .xlsx", "Save as pdf", or "Email as pdf" buttons to work. If anyone is willing to help me get this set up, I would be extremely grateful.
Watching the video, I still find it difficult to refer to the emPL software that sends receipts and salary slips automatically via email or Zalo.
Mr. Chester,
My name is Rosie. I have a problem with this macro. When I tried running it, my malwarebytes blocked it. It detected an exploit and I couldnt run the macro
Mr. Chester, when I push the macro buttons to record in my record of invoice sheet. It records the invoice, but it creates a new line for each macro I push. It doesn't put all the information for each macro on one line. Can you please help?
Can I use gmail instead of outlook, sir?
Hey mate. Amazing teaching. I have one question. I want to basically convert this template into a receipt and so where you have 'term 30,60,90' I have put 'Paid' into that list. This works for everything else, except when I try to email it it says 'mismatch' the debugger sends me to the VBA sub and highlights where term should be a number but mine says Paid. It's really not liking this, how do I fix?
hi mr chester. thanks a lot for your tutorial video. it really help me a lot. just asking can u help me with tutorial on how to attach pdf file and send via whatsapp desktop. currently i manage to open the exe app using syntax Shell ("C:\TEST\whatsApp.exe") but got no idea on how to attach the file like what you did on this email tutorial. really hope u can help me with this. thanks a lot sir
Hi!. I am getting an error in the vba statement Set EItem = EApp.CreateItem(0). could you please clarify
How can we use WhatsApp to send these invoices? Any guide please! Thank You.
I created my own bulk invoicer for my business by watching this 6 videos.
I got a trouble at last step which is making the EApp defining and object creation. There is a error cord debugging this Epp object creating.
Please kindly help me.
Hi, I am trying to also attach the file as an excel sheet (without the macros etc) as well. Is this possible?
So if I do not have the Outlook application and only have MailandCalendar how do I go about setting that MailandCalendar as the application?
More specifically I'm getting an error ActiveX component can't create object and it is on the line of Set Eapp when creating the Outlook App.......
When mine makes the pdf, it is a mess of letters, you can't even read it. Can you advise me?
Have loved this series/playlist, but have run into a snafu that doesn't seem to have an answer in the comments...how to send the pdf if it's going to be used on a Mac? I'm assuming the code is different and is probably also running into the walls of the sandboxing?
I am afraid I am not a Mac user so I can't help.
I'm using Gmail. Still can't figure the code out
Goede avond. ben bezig met email pdf ik gebruik gmail. hoe kan ik de vba code aanpassen?
met Set Eapp = CreateObject("Outlook.Applcation") lukt het niet. Heb ook op de link gekeken
maar daar kan ik geen wijs uit worden.
Ik zie u antwoord graag tegemoet
Thank you
With sending via email, how do I code it for gmail and not outlook?
how do you use gmail instead of outlook application.
because my outlook is not working
awesome thanks!
Can anybody tell me why this comes up with an error saying it cannot find the file?
I did this and the email is not going through... i send it and i never recieved it... is it because it is an html?
It does not work on a MAC machine. Microsoft note "Outlook for Mac and OneNote for Mac don't support VBA." Is there a way to overcome this. Thanks
Yes it will. First save your workbook (file) to macro. Xlsm. Then go to the trust center in your Excel file menu
How? please share@@rosieval6994
super
How to send pdf file of invoice via whatsapp
I tried this, but i keep getting an error with the "invno = Range("#"). Also, can I use this with AT&T Yahoo.Mail?
I love this videos but I am in dire need of help pleaseee! I am using a Mac book so I decided to use the mail application instead of outlook. I am using the code below but the pdf is not attaching to the email. I am not sure what I am doing wrong Sub SaveAsPdfAndSendEmail()
Sub SaveAsPdfAndSendEmail()
Dim path As String
Dim invno As Long
Dim custname As String
Dim fname As String
Dim amt As Currency
Dim dt_issue As Date
Dim term As Variant
' Set the file path and other variables
path = "/users/keenyabrowne/desktop/steven file/"
invno = Range("C3").Value
custname = Range("B8").Value
fname = invno & " - " & custname
' Construct the AppleScript code
Dim applescriptCode As String
applescriptCode = "tell application ""Mail""" & vbNewLine
applescriptCode = applescriptCode & "set Eitem to make new outgoing message with properties {subject:""Invoice for: " & custname & """, content:""Please see attached From, SM.""}" & vbNewLine
applescriptCode = applescriptCode & "tell Eitem" & vbNewLine
applescriptCode = applescriptCode & "make new to recipient at end of to recipients with properties {address:""" & Sheets("Invoice for Printing").Range("B12").Value & """}" & vbNewLine
applescriptCode = applescriptCode & "tell content" & vbNewLine
applescriptCode = applescriptCode & "make new attachment at after last paragraph with properties {file name:""" & path & fname & ".pdf""}" & vbNewLine
applescriptCode = applescriptCode & "end tell" & vbNewLine
applescriptCode = applescriptCode & "end tell" & vbNewLine
applescriptCode = applescriptCode & "activate" & vbNewLine
applescriptCode = applescriptCode & "end tell"
' Execute the AppleScript code
MacScript (applescriptCode)
End Sub