Rocky Smolin
rockysmolin at bchacc.com
Sun May 6 15:15:54 CDT 2012
I've got to do mail merge for a client this week - couple of letters with addresses, salutations, class data, etc. Pushed into a form letter from Access. I did this once before and it worked - with a template with fields - so I suppose I can do it again. But it was a number of years ago and it seemed rather kludgey. I'm still using 2003 for development. Any pointers, tip, guidelines, new methods or anything? I can crib my code out of that other app and modify it so I guess it won't be the job it was the first time. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Sunday, May 06, 2012 7:59 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Background Color for Entire Access Report Page A mail merge is quite different from making Access act like Word. Mail merges work well, and pushing data into named bookmarks in a Word template is very effective. I've used both from Access, but a band report generator simply doesn't have the fine control over the document conditions that Word has. In dot net you have finer control but you generally work with third party tools and you have to control EVERYTHING! Charlotte Foust On Sat, May 5, 2012 at 4:41 PM, Mark Simms <marksimms at verizon.net> wrote: > Extremely interesting response, Charlotte. > I performed a Word mail-merge from Access..it was adventurous, but > worked well. > Dot net developers got the re-write contract (I mentioned this > before), but they could not pull it off. > > > Any time you try to make Access reports behave like Word, you run > > into roadblocks. Fortunately, there are usually workarounds, but > > sometimes the effort required is simply not worth it for the result > > achieved. > > Charlotte Foust > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com