Rocky Smolin
rockysmolin at bchacc.com
Sun May 6 17:21:51 CDT 2012
Small volume 5-20 at a time. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Sunday, May 06, 2012 1:23 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Background Color for Entire Access Report Page Are you actually doing a mail merge with fields for a large mailing or pushing data into bookmarked spaces for a letter or two? Charlotte On Sun, May 6, 2012 at 1:15 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > 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 > > > > -- > 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