emailing from Access

  • Thread starter Thread starter MU-TCRC
  • Start date Start date
M

MU-TCRC

hello, I keep contact info in a database and need to know if I am able to
send an email to more than one contact at a time. I am able to send
individual emails, but now as a group. And when I import the contact info to
Outlook I have to go in and edit the emails as they have # signs infront and
behind the email. I must be missing a step somewhere.....Please help!
 
Did anyone ever answer you on this or did you ever figure it out because I
was wondering the same thing.
 
Nope, no one answered this............It's really frustrating. I have an
existing database with contact information, namely emails. I know there are
spamming issues with being able to do this, but I am needing to be able to
send correspondence to groups of people. You can use outlook to create
contacts to get the same outcome. You can export your database info to
outlook contacts, but when you do the information is distorted and you have
to go in and edit each contact for their email address to work which is just
not effective. Though I have had to resort to exporting from Access to
Outlook for my news release list resulting in keeping two versions of the
same information.
 
I am trying to send emails to an event database. This is very, very
frustrating. I wouldn't have used Access if I had know of this limitation.
Has anyone found a solution?
 
Jill,

I send emails to multiple people every day. Have you looked at the help
text for the SendObject command? You need to format your "To" field as a
string with semicolon separators.

To - The recipients of the message whose names you want to put on the To
line in the mail message. If you leave this argument blank, Access prompts
you for the recipients' names.

Separate the recipients' names you specify in this argument (and in the Cc
and Bcc arguments) with a semicolon (;) or with the list separator
(separator: A character that separates units of text or numbers.) set on the
Number tab of the Regional Settings Properties dialog box in Microsoft
Windows Control Panel. If the mail application can't identify the
recipients' names, the message isn't sent and an error occurs.

One other possibility is to talk to someone who knows how your mail server
works. My system allows me to create groups and mailing lists so I can send
an email to (e-mail address removed) and it will go to the whole group.

Hope this helps
 
Back
Top