Choose database and table
Good article but it would be really useful to know how to add an attachment to an email that is going to multiple people. As an example I want to send a cover letter and a copy of my resume to 10 different recruiters from my contact list. Thanks sam
Very Nice !! Wish you'll could have posted the same as a PDF Download. The PDF format enables us to easily save it for future reference. Great Work though !! Rgds, Prakash.
Seems MS has forgotten their own Office database, Access. They have not had a good mail merge with Access data since Office 2000. Can't select a query, the selection options are poor. This means you have to go through the entire selection and sort issues with every mail merge.
OK, I now have a custom set of letters to a group of Outlook Contacts. Why would I want to print and snail-mail them? I want to Send them, emailing each to the specified Contact.
I always add a new column, call it "Sorted" and set the sort in that field. If I need a specific filter sort, I will add a new column called "FILTER" field and set it that way. This allows my to better separate and sort my date when merging. I can include or exclude parts as well as sort them. I can even have multiple sort types by including my FILTER fields. ...or... Filter and sort manually, then save separate XLS files for each sort. Then when merging you don't have to verify the data as anything there is only for that particular sort.
You can use mail-merge for email distribution, the same way you would do for printing, but instead choose To Email (not Send To from File Menu), HOWEVER...you need to check what your outbound limit is from your ISP....attachments for bulk distribution is frowned upon and can lead to service termination. Its best if you will be proving an attachment to reference a URL in your doc to a web location. 1000ish emails x small attachment = LARGE MAIL QUEUE and server strain. I use a PHP app for distributions, fully supports HTML, love it. One issue I had with Office (e)mail-merge was all emails would queue, sit in the outbox (Bold, meaning unread) and never send. I would have to open, then close each of the emails...then it would send - I wouldn't even have to make a change. I uninstalled and reinstalled twice - really annoying.