Novice totally stuck - need to send emails

[puddinchops]

Hello
I am totally new to access - but I need to use it. We have a small hotel and I need to email customers.

I have watched the Access Learning Zones utube videos and I have a lovely Customer Table with hyperlink email address field.

I am now stuck.

I need to send regular emails to select customers (approx 300) via outlook. They dont necessarily need to be personallised.

I dont know how to do it. I have tried to copy and paste the whole column but it puts # inbetween the email addresses.

please can someone help?

 

[Estuardo]

Helllo and Welcome!
If you really novice, i wouldn't use outlook (yet!) to send emails. I would do it with access own tools. here, Paul Eugin and Nigel Shaw posted a neat solution to send emails to a group from a table via Access.
G'd luck

 

[puddinchops]

Hello

Many thanks for your reply. I dont think that is really going to help.

Perhaps I have not explained what I want to do properly.

I have a Customer table (CustomerT) with name, address, etc & emailaddress (as a hyperlink)

I organise specialist courses and I want to send the same email out to every email address I have and also attach PDFs and word documents.

In the past I have done this by copying and pasting email address from excel to outlook, but thought I would be able to use Access to keep a better hold on my contacts.

If it is the code I need to use from the answer above - where do I put it?

thanks again