Email to groups

K

kltino

I have letters to be sent to a list of people through email. The email list
can change from week to week. Is there a way to automatically assign the list
to the letter. I tried the Send to in the macro but couldn't get it to work
without entering the email addresses. Thanks for any info you can give me.
 
P

Pendragon

While you can go through programming a routine to create an email message (I
assume you are using Outlook), I have found it to be very easy and efficient
in creating an export of the data to a text file and using that as a data
source to a Word merge template. From Word, you simply click on Merge to
Email and each individual email address receives the document as the email
body of text (not as an attachment).
 
R

Ron2006

An alternative:

If you have a single email list then create a table composed of
records with each email address as a record. Then as part of the email
creation process loop through the table concatenating the addresses
into a text field that is loaded into the x.TO element of the email.

If multiple email lists, then have two fields in the table: one for
the list and one for each email in that list and then use a query
limited by the list you want to do the same as above.

Add a form to you application to maintain the list(s) so you don't
have to update the table directly. That way you can have the users
update the table as required.

You will need to either do step one or two as part of email
automation, using vba to create the email.

Or

add a txtbox to your form and have a button that causes the on click
event to load the address into that text field that the macro can then
reference. The field can even be hidden. or have it visible and let
user modify it between the time of pushing the load address button and
the create email button.

Just some ideas.

Ron
 
Top