eric86vabeach
New Member
- Joined
- Jan 29, 2014
- Messages
- 23
can this be done? i would like to set a work sheet up like this..... and when date is =TOday() then send out email to the email to the email that is scheduled to send though Gmail and the subject would be
the subj. column be "d","g" ect....
the email waould be the emailed on the date that is in cell f3,i3 ect
the body would be e3,h3 ect
if you want to email me for more info do so @ [address removed]
[TABLE="width: 500"]
<tbody>[TR]
[TD]row #[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[TD]j[/TD]
[TD]k[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]user name[/TD]
[TD]user@gmail.com[/TD]
[TD] gmail password[/TD]
[TD]password here[/TD]
[TD]blank[/TD]
[TD]blank[/TD]
[TD]blank[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]frist name[/TD]
[TD]last name[/TD]
[TD]email[/TD]
[TD]email subj.[/TD]
[TD]email1[/TD]
[TD]email 1 date[/TD]
[TD]email subj.[/TD]
[TD]email 2[/TD]
[TD]email 2 date[/TD]
[TD]so on [/TD]
[TD]and so on[/TD]
[TD]and so on and.... [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]eric[/TD]
[TD]smith[/TD]
[TD]blah@gmail.com[/TD]
[TD]thanks from....[/TD]
[TD]thanks for signing up Blah Blah blah[/TD]
[TD]2/28/2014[/TD]
[TD]you won!!![/TD]
[TD]you have won a fee game of bowling blah blah [/TD]
[TD]3/5/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]john[/TD]
[TD]john[/TD]
[TD]Blah@yahoo.com[/TD]
[TD]thanks from....[/TD]
[TD]thanks for signing up here is a free game of golf[/TD]
[TD]3/1/2014[/TD]
[TD]FREE!!![/TD]
[TD]here is a coupon for a free drink the next time you come in[/TD]
[TD]3/25/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
the subj. column be "d","g" ect....
the email waould be the emailed on the date that is in cell f3,i3 ect
the body would be e3,h3 ect
if you want to email me for more info do so @ [address removed]
[TABLE="width: 500"]
<tbody>[TR]
[TD]row #[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[TD]j[/TD]
[TD]k[/TD]
[TD]l[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]user name[/TD]
[TD]user@gmail.com[/TD]
[TD] gmail password[/TD]
[TD]password here[/TD]
[TD]blank[/TD]
[TD]blank[/TD]
[TD]blank[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]frist name[/TD]
[TD]last name[/TD]
[TD]email[/TD]
[TD]email subj.[/TD]
[TD]email1[/TD]
[TD]email 1 date[/TD]
[TD]email subj.[/TD]
[TD]email 2[/TD]
[TD]email 2 date[/TD]
[TD]so on [/TD]
[TD]and so on[/TD]
[TD]and so on and.... [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]eric[/TD]
[TD]smith[/TD]
[TD]blah@gmail.com[/TD]
[TD]thanks from....[/TD]
[TD]thanks for signing up Blah Blah blah[/TD]
[TD]2/28/2014[/TD]
[TD]you won!!![/TD]
[TD]you have won a fee game of bowling blah blah [/TD]
[TD]3/5/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]john[/TD]
[TD]john[/TD]
[TD]Blah@yahoo.com[/TD]
[TD]thanks from....[/TD]
[TD]thanks for signing up here is a free game of golf[/TD]
[TD]3/1/2014[/TD]
[TD]FREE!!![/TD]
[TD]here is a coupon for a free drink the next time you come in[/TD]
[TD]3/25/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Last edited by a moderator: