[AccessD] Mail Merge

Mark A Matte markamatte at hotmail.com
Wed Jan 23 12:20:33 CST 2008


Rocky,

I have a db that generates 500-1000 letters a week...I think there are about 30 different types of letters...but only 1 or 2 Reports in Access.  All of the text from the letters is stored in a table.  I use some conditional formatting on the report to change a few things depending on what type of letter(change logo,greeting, ect).

Each letter includes specific info Name,Product, caseID...and such from a query/table.  Its like a mail merge...but WORD is never used or referenced.  I never create a .doc, I just print from access.  This way...I don't have any other files to keep up with...just the db...and now I have reports like...this many letters of this type were printed on this day...yada yada yada...

Wasn't sure if you were looking at something like this...or an actual MSWord.doc.

Mark A. Matte


> From: rockysmolin at bchacc.com
> To: accessd at databaseadvisors.com
> Date: Wed, 23 Jan 2008 09:51:45 -0800
> Subject: Re: [AccessD] Mail Merge
>
> Mark:
>
> It's merging into a variety docs that have the fields inserted into them.
>
> Rocky
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> Sent: Wednesday, January 23, 2008 8:26 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Mail Merge
>
>
> Rocky,
>
> Are you needing a formated Word document...or are you just printing from an
> access report...and it looks like a doc?
>
> Thanks,
>
> Mark A. Matte
>
>
>> From: rockysmolin at bchacc.com
>> To: accessd at databaseadvisors.com
>> Date: Wed, 23 Jan 2008 07:59:20 -0800
>> Subject: [AccessD] Mail Merge
>>
>> Dear List:
>>
>> I need to do a simple Mail Merge Access-->Word and don't want to
>> reinvent the wheel. Is there a canned routine on line that I could
>> crib? I checked Lebans but didn't see anything.
>>
>> MTIA
>>
>> Rocky
>>
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> Need to know the score, the latest news, or you need your HotmailR-get your
> "fix".
> http://www.msnmobilefix.com/Default.aspx
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.8/1236 - Release Date: 1/21/2008
> 8:23 PM
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Shed those extra pounds with MSN and The Biggest Loser!
http://biggestloser.msn.com/



More information about the AccessD mailing list