Save & Send excel workbook in Gmail

Hi there! I'm creating a shift log for our concierge to complete and I wanted to add a button in the sheet that they can click and it will save & send the workbook in an email through gmail. I have the email part working, but I can't figure out how to get it to attach the workbook. I had removed .attachements.add activeworkbook.fullname because the code didn't work at all with it in there.

IMPORTANT: I'm an extreme noob to VBA and what I have so far is just from google searching. I appreciate any help anyone can offer!

It wont let me post the code, it keeps saying "You are not allowed to post any kinds of links, images or videos until you post a few times."

Originally Posted by Leith Ross

Hello TCoffee2016,

Welcome to the forum!

What program are you using to send the email? My guess is Outlook.

I'm using excel and trying to send the email through gmail.

but the question is is gmail

• An account that is linked to an email client (outlook, thunderbird etc)
• An account that you access by using an brower (edge, chrome firefox etc) and then compose the email from there?

the first option is easy, the second much harder

Originally Posted by davsth

but the question is is gmail

• An account that is linked to an email client (outlook, thunderbird etc)
• An account that you access by using an brower (edge, chrome firefox etc) and then compose the email from there?

the first option is easy, the second much harder

The 2nd I can get it to send the email, its just getting it to save and attach the current workbook that's proving difficult.

Originally Posted by Leith Ross

Hello TCoffee,

I have an Invoice program I wrote to save the worksheet as PDF and then email it using my Gmail account. You will need to edit the code to change the User Name, Password, Email address or addresses, subject line, and the email body to match your own.

This code will run correctly if you are signed into to your gmail account.


End Sub
[/code]

This was working great until I changed the body of the email text, now I'm getting an error saying:

Rune-time error '-2147024864 (80070020)':

The process cannot access the file because it is being used by another process.

In the module it highlights the .addAttachement FileName