Sending emails to automatic list of recipients

[Calle]

Hi there,

this is my first post and I hope that I will be specific in what I need.

In attachment I am presenting a simple table in Access. What I am trying to do is to send automatic emails to everyone listed in email address column according to the right sequence:

Dear <Title>,

Please find your current salary attached. (and to each email I want to add the attachment loaded to Access).

Firstly I was trying to merge with Word the right letter but then I got lost what should do next.



Anyone could help me?

Many thanks in advance.

[ranman256]

Make a form, in it is a list box of the names, id, emails. (Query)
the list box will be set to 3 columns.
put a button to send the emails.
clicking the button will scan the list,sets the listbox to that individual, (ID),
the report is bound to a query that uses only the person selected in the listbox,
(select * from table where ID= forms!frmMyForm!lstBox)

heres the code:

sub btnSend_click()
For I = 0 to lstBox.listcount-1
    Itm= lstBox.itemData(I)   'Get next item in list
    LstBox= itm                   'Set listbox
    VTo = lstBox.column(2)   'Get the email address from column

    Docmd.sendObject acReport, "myReport".....
next
end sub

[Calle]

Thanks for answering.

I think I did it how you described but each time debugger appears....

Could you please take a look?

[ozsupra]

Make a form, in it is a list box of the names, id, emails. (Query)
the list box will be set to 3 columns.
put a button to send the emails.
clicking the button will scan the list,sets the listbox to that individual, (ID),
the report is bound to a query that uses only the person selected in the listbox,
(select * from table where ID= forms!frmMyForm!lstBox)
[/code]

ranman256
I have put this together for Calle
Are you able to finish as a working process?
Thanks,
A.

[Calle]

Hi,

thank you for preparing this for me. However by clicking the button I can send the report consisted of data regarding people that are checked in the form. How could I create and send email to each person individually that consists of certain data. Like in the example:

Dear <here put the name of the person>,

Please find your current salary attached. (and to each email I want to add the attachment loaded to Access). ?

[ozsupra]

Hi Calle,
I'm actually an Excel programmer and although MS Acces is similar it isn't quite the same as access. I have never done this so bear with me.

I believe the process could be (remembering there are many ways to skin a cat)

1) Create a table where you store the persons names and email addresses
2) Create a second table where you import their salary statements
3) Then another to store the text components you need within the email
3) Next create a query where the statements are linked to the person and it only shows their latest statement
4) Finally using the previous process add the missing components to outbound e-mails.

Do a search for sending e-mails from Access and see what others have done... that's where I solve 90% of my questions.

Sorry I can help further,
A.

[ozsupra]

This looks promising....

http://www.granite.ab.ca/access/emai...samplecode.htm