[AccessD] Mail Merge

Mark:

Gotta be WORD.

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 10:21 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Mail Merge


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/
--
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