I had tried but this code failed to display the message that i want to send.
can anyone fix this??
function CustomEmail() {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange("A1:I10");
//var UserData = range.getValues();
//for (i in UserData) {
//var...
Hello, can someone help me to make VBA Macros code to send email from google spreadsheet.
i wanna create a button so when i click that, i can send email to xxxx@gmail.com (only this email)
The subject is C9
The message is A1:I10
This is my file. i hope someone will gladly help me
thanksss
thank you very much you know what i need.
i really appreciate your help.
but to be honest that file only for my practice.
my true project has 5000 data and i cant upload coz of privacy.
im still noob on coding and need more practice.
i still need your hand.
my project print area is A1 to AP103...
WOW THANKSS THAT WHAT I LOOKING FOR :DD
That will save my time, thank you very much
but can i ask something
what if i have 5000 data & then i only want to create PDF from data ID 400 to 1000 which code that i need to replace or add?
From A1 to B3.
I want to have All pdf file (total 15 PDFs) with sheet "Card" format from ID 10001 to 10015 with just one click.
i hope someone know the Code so i can do that
Hello my name is Roger.
I wanna create multiple PDF files with cell value as file name.
i found this code in internet
Sub Rectangle1_Click()
On Error Resume Next
MkDir ThisWorkbook.Path & "\SAVE AS PDF\"
On Error GoTo 0
Filename = Sheets("Card").Range("B1") & "-" &...