Sending a Outlook Greeting Card using MS Access 2

[istone]

Hi All,
First of all Happy Holidays.
We usually do this piece manually. I want to find out if it's possible to send a Greeting card (Outlook card) to all our clients using their email address that we have in our database. The goal will be to create a button in a form and once clicked on it'll send the same card to all the clients using their email address we have in the table.
Thank you in advance

 

[istone]

thanks Remou, when i read GingerR' and since it worked I did not read further. The last code you sent me shows an error "File has been deleted or moved", send to only one, and this line is highlighted: .To = rs!Email
GingerR works except that it include all clients addresses.

 

[Remou]

What is the value of rs!Email? This error message is unfamiliar.

 

[PHV]

Some code in the wrong place:

...
Do Until rs.EOF
  [!]Set objEmail = objOutlook.CreateItem(olMailItem)[/!]
  With objEmail
    .To = rs!Email
    .Subject = "Happy Holidays"
    .HTMLBody = "Greetings from Chernoff Diamond<br><br>"
    .Attachments.Add "P:\Greetings.jpg", olByValue, , "Stuff"
    .Send
  End With
  rs.MoveNext
Loop
...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886