ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Email from Excel - help no spam - genuine business work (https://www.excelbanter.com/excel-discussion-misc-queries/136289-email-excel-help-no-spam-genuine-business-work.html)

[email protected]

Email from Excel - help no spam - genuine business work
 
Help with automated email using excel. NOT SPAM

Hi there i have an expenses report from work and i need to send this
to each mail address in a list
More detail........

Cell A1
A2 A3
Alex radford Your expenses for this week are £10.00



See above this is my format in excel, but i have many lines (range of
around 50 lines) i would like to send an email to each individual
person returning in the body of the email the text in A2. So when i
have compiled my information in the list i can run the macro and it
automatically sends the mail without me having to click send all the
time.

I am quite new to VBA in excel but i am a quick learner and use many
functions etc..

Can anyone help i am prepared to send mail via my works email...
,

Thanks to all
Alex


Niek Otten

Email from Excel - help no spam - genuine business work
 
Hi Alex,

http://www.rondebruin.nl/mail/add-in.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message oups.com...
Help with automated email using excel. NOT SPAM

Hi there i have an expenses report from work and i need to send this
to each mail address in a list
More detail........

Cell A1
A2 A3
Alex radford Your expenses for this week are £10.00



See above this is my format in excel, but i have many lines (range of
around 50 lines) i would like to send an email to each individual
person returning in the body of the email the text in A2. So when i
have compiled my information in the list i can run the macro and it
automatically sends the mail without me having to click send all the
time.

I am quite new to VBA in excel but i am a quick learner and use many
functions etc..

Can anyone help i am prepared to send mail via my works email...
,

Thanks to all
Alex



[email protected]

Email from Excel - help no spam - genuine business work
 
On 26 Mar, 12:44, "Niek Otten" wrote:
Hi Alex,

http://www.rondebruin.nl/mail/add-in.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in ooglegroups.com...

Help with automated email using excel. NOT SPAM

Hi there i have an expenses report from work and i need to send this
to each mail address in a list
More detail........

Cell A1
A2 A3
Alex radford Your expenses for this week are £10.00


See above this is my format in excel, but i have many lines (range of
around 50 lines) i would like to send an email to each individual
person returning in the body of the email the text in A2. So when i
have compiled my information in the list i can run the macro and it
automatically sends the mail without me having to click send all the
time.

I am quite new to VBA in excel but i am a quick learner and use many
functions etc..

Can anyone help i am prepared to send mail via my works email...
,

Thanks to all
Alex


Thanks for that but i have tried this an it doesnt fit my needs, i
have installed the sendmail but that attaches the whole work book and
not just my body text, i need this to also send for me and me not
click the send button? any help? please


Bob Phillips

Email from Excel - help no spam - genuine business work
 
See http://www.rondebruin.nl/mail/folder2/mail4.htm

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
On 26 Mar, 12:44, "Niek Otten" wrote:
Hi Alex,

http://www.rondebruin.nl/mail/add-in.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in
ooglegroups.com...

Help with automated email using excel. NOT SPAM

Hi there i have an expenses report from work and i need to send this
to each mail address in a list
More detail........

Cell A1
A2 A3
Alex radford Your expenses for this week are £10.00


See above this is my format in excel, but i have many lines (range of
around 50 lines) i would like to send an email to each individual
person returning in the body of the email the text in A2. So when i
have compiled my information in the list i can run the macro and it
automatically sends the mail without me having to click send all the
time.

I am quite new to VBA in excel but i am a quick learner and use many
functions etc..

Can anyone help i am prepared to send mail via my works email...
,

Thanks to all
Alex


Thanks for that but i have tried this an it doesnt fit my needs, i
have installed the sendmail but that attaches the whole work book and
not just my body text, i need this to also send for me and me not
click the send button? any help? please



Ron de Bruin

Email from Excel - help no spam - genuine business work
 
Maybe you can use this
http://www.rondebruin.nl/mail/folder3/message.htm

Or
http://www.rondebruin.nl/mail/folder3/row.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
On 26 Mar, 12:44, "Niek Otten" wrote:
Hi Alex,

http://www.rondebruin.nl/mail/add-in.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in ooglegroups.com...

Help with automated email using excel. NOT SPAM

Hi there i have an expenses report from work and i need to send this
to each mail address in a list
More detail........

Cell A1
A2 A3
Alex radford Your expenses for this week are £10.00


See above this is my format in excel, but i have many lines (range of
around 50 lines) i would like to send an email to each individual
person returning in the body of the email the text in A2. So when i
have compiled my information in the list i can run the macro and it
automatically sends the mail without me having to click send all the
time.

I am quite new to VBA in excel but i am a quick learner and use many
functions etc..

Can anyone help i am prepared to send mail via my works email...
,

Thanks to all
Alex


Thanks for that but i have tried this an it doesnt fit my needs, i
have installed the sendmail but that attaches the whole work book and
not just my body text, i need this to also send for me and me not
click the send button? any help? please



All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com