PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO EMAIL GOOGLE SHEET

INTRODUCTION

GOOGLE SHEET is growing popularity exponentially due to many benefits it offers to its users.

One of the best GOOGLE SHEET benefits is its usage in sharing. Although this is available now in almost all the advanced spreadsheet software but even then , the ease and accuracy provided by GOOGLE SHEET is exceptional.

Many times when we are auditing a report, we need to share the report with many colleagues or seniors.
What if the sharing directly in google sheets is not taking place and we need to send the report via email.
 
The normal procedure of the email is to download the sheet to the pc, login to your account and then attach it and send.
We are lucky that google sheets have a direct BUILT IN method to send the google sheet through email that also in the format we want.
So let us find out how we can send the google sheet through email to many recipients.
 

DIFFERENT FORMATS IN WHICH WE CAN EMAIL GOOGLE SHEETS

GOOGLE SHEETS supports many famous and frequently used formats which can be e mailed directly to many recipients.

The following formats are supported by GOOGLE SHEETS.

PDF (.PDF)

OPEN OFFICE SPREADSHEETS (.ODS)

MICROSOFT EXCEL (.XLSX)

 

WHERE TO FIND EMAIL OPTION IN GOOGLE SHEETS
EMAIL OPTION LOCATION IN GOOGLE SHEETS

STEPS TO SEND GOOGLE SHEET AS EMAIL

After the sheet is ready , we can use the following steps to email it directly for the review.

  • Go to FILE>EMAIL AS ATTACHMENT.
  • EMAIL AS ATTACHMENT dialog box will open with a number of option.
The EMAIL AS ATTACHMENT DIALOG BOX is shown below.

 

 

EMAIL GOOGLE SHEET
ENTER THE EMAIL ADDRESS AND CHOOSE THE ATTACHMENT TYPE

DIFFERENT FIELDS IN EMAIL AS ATTACHMENT DIALOG BOX

 

SEND YOURSELF A COPY CHECKBOX: If checked, it’ll send a copy of email to you.

TO: Enter the email address or many address whom you want to send the sheet.

SUBJECT: Enter the subject of the email.

MESSAGE: Enter the message of the email.

CHOOSE TYPE OF ATTACHMENT FROM THE DROPDOWN: PDF for pdf, OPEN OFFICE SPREADSHEET for ods and MICROSOFT EXCEL for .xlsx format.

SEND: to send the email with your sheet as attachment.

STEPS CONTINUED..

  • Enter the Email address of the Addressee.
  • Enter the subject and message.
  • Choose the attachment type you want the sheet to be mailed as.
  • Click SEND, and the mail will be sent with your sheet as the attachment.

WHAT IS SENT IN EMAIL WHEN GOOGLE SHEET IS MAILED

Not every time we have time to try many options. So we must be very clear , what would be mailed when we use the EMAIL AS ATTACHMENT functionality of GOOGLE SHEETS.
So, the following description shows the content of the attachment.
 
PDF: All the sheets will be mailed and will be presented on the page after page. It means if we have 4 sheets, the pdf would contain all the four sheets starting from the first sheet printed on the first page followed by the second and so on till the last sheet on the last page.
If a sheet is to be printed on many pages, it’ll be on those many pages in pdf.
 
OPEN OFFICE SPREADSHEET: Complete workbook will be mailed with all the sheets.
 
MICROSOFT EXCEL: Complete workbook will be mailed with all the sheets.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: