MAIL MERGE WITH SCHEDULER FOR GMAIL & GOOGLE APPS || SK SAIFUDDIN
MAIL MERGE WITH SCHEDULER FOR GMAIL & GOOGLE APPS
#MAIL_MERGE. #GOOGLE
HELLO FRIENDS,
Iss video mai appko google mail merge with scheduling system ko pura explain kiya hua hai.
App niche diya hua process follow krke, isse asani se sikh sakhte hai.
INSTALL "Mail Merge with attachment"
Open "Google SpreadSheet"
open "Google Sheets" (1st link)
select "Go to Google Sheets"
select "Blank"
Go to "Add-ons"
select " Get add-ons"
and then search "Mail Merge"
select "Mail Merge with attachment"
Install it.
continue
as "GMAIL_ACCOUNT "
select "Allow"
(MUST BE SIGN OUT ALL OTHER GAMIL ACCOUNTS.)
After installation.
ADD VALES
Go to "Add-ons", "Mail merge with attachments"
and select the "Create merge sheet".
First Name, Last Name, .. series of fields is there,..
You can manually types the names,
or
Open "google contacts",
if you have contacts, then okay,
if not, then download from this link:
For sample LINK: https://letterhub.com/sample-csv-file...
after importing,
Go to 'Labels',
Create a new 'label'.
NOW, select some contacts,
and select "MANAGE LABEL",
select created Label and apply.
Now, Switch to Google Untitled spreadsheet,
Go to "Add-ons" , select "Import Google Contacts".
Select a label to be imported.
and select "Import Contacts".
Then Automatically, Contacts are listed.
(You can add more)
We can add Column and set values accordingly.
FILE ATTACHMENT
Select the appropriate column
here switch to google drive, and select a file.
open that file,
and copy the link(URL),
for multiple links, Separated by comma(,)
OR,
we can import it from "ADD-ons"
Go to "Add-ons", Select "Mail-merge attachments" select "Add file attachments" and select "insert a file from drive".
Automatically, attachments are done.
SCHEDULE DATE
Select a scheduled date and at that time MAIL IS SENT.
If sent immediately, leave it as blank.
CONFIGURE MAIL MERGE
NOW, Go to "Add-ons", and select "Configure Mail Merge".
YOU CAN SELECT ANOTHER SENDER'S EMAIL,
SET A SENDER'S NAME, AND
now SET "REPLY-TO-ADDRESS".
WHERE YOU WANT TO GET REPLIES.
PRESS "CONTINUE",
now, for ENABLE EMAIL TRACKING
PRESS "CONTINUE",
now, for "CREATE EMAIL TEMPLATE"
SELECT "code your own HTML"
(a box appears here, fields are within double curly brushes)
{{First Name}}'s meeting with {{Executive Name}}
Above code is used as SUBJECT LINE:
FOR Message,
Dear {{First Name}},
Your meeting with {{Executive name}} is scheduled for {{Interview Date}} at {{Venue}}, see you!
and press "SAVE"
and select " Run Mail merge"
and select "GO".
After compilation, a message is shown there.
Now Check it, how it looks like at recipient computer,
check all values,
Go to MAIL MERGE SHEET,
go to "ADD-ONS", select "CONFIRM"
After continue,
Go to "Create Gmail Drafts"
Go.
After that, emails are drafted.
It is locked here,
COMPOSE MAIL
For the subject,
{{First Name}}'s meeting with {{Executive Name}}
FOR Message body,
Dear {{First Name}},
Your meeting with {{Executive name}} is scheduled for {{Interview Date}} at {{Venue}} , see you!
leave it as it is,
it will be saved as a draft.
Go to Spreadsheet,
Configure Mail Merge.
select "Create Email Template",
select "Use a Gmail Draft".
Select "Unsend mail"
and then continue,
Let's check how it looks like on the recipient computer.
Thanks for watching.