Hi,
I am technically apt but an Access newbie.
I need some advice on using Outlook, Word, Access and Excel to create and maintain a large list of address book information and using this list to generate mailing labels and presonalised bulk emails.
I will soon have a list of about 4000 industry contacts that I will send postal mail and email to them on regular occasions.
I’ve already worked out how to create mailing labels using a mail merge in Word from either the Outlook Address Book or a Comma Seperated File.
What I may need to do is set up distribution lists in Outlook so that I can easily email announcements out to regional contacts.
However I am concerned at having 4000 contacts in an Outlook address book – is this too many?
Instead, I am considering storing all contact information in an Access database and having a macro that replicates Outlook’s ability to send email to distribution lists.
The issues are (funnily enough…) :
Will this macro create 4000 emails and send them?
Will it instead be able to send a single email with the 4000 addresses in the BCC field?
Can it create personalised emails so that each email contains the recipient’s name in the message (or is this an Outlook form)?
I initially thought to use an Excel spreadsheet to enter the information into due to the speed you can enter data for 4000 contacts, and then you can import this CSV file into Outlook.
Another concern is being able to select only a portion of the address book to use as mailing labels in Word.
Can I not have an Access database with Queries (which I know how to make) that select particular Countries and States and feeding information into a Macro that will either send email or create mailinglabels?
I am thinking surely this thing has been done before?