Email from Excel - help no spam - genuine business work

A

ALEX.RADFORD

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
(e-mail address removed)


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...
(e-mail address removed),

Thanks to all
Alex
 
N

Niek Otten

Hi Alex,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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
(e-mail address removed)


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...
(e-mail address removed),

Thanks to all
Alex
 
A

ALEX.RADFORD

Hi Alex,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


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
(e-mail address removed)

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...
(e-mail address removed),

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
 
B

Bob Phillips

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)



Hi Alex,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

message
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
(e-mail address removed)

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...
(e-mail address removed),

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
 
R

Ron de Bruin

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


Hi Alex,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


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
(e-mail address removed)

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...
(e-mail address removed),

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top