[mso] Re: Excel-Distribution help request_thnx

Hey Tiffani,

It sounds as though you're using EXCEL as a mail merge database.
Nothing wrong with thaqt... Unless you have to alter the data every
"merge"... By a lot.
Sure you don't want to convert to ACCESS?? :-)

Anyways...

If I understand you there are a variable number or rows that you are
adjusting/updating for each person for each distribution.
Is this correct? 

Does your list span years?
That is... Do you have more than 12 columns?

Are the number of documents sent to the people who are "related to a certain
unit" constant for each person?

The generic document may be whatever, but since it's sent to the world, is
not a problem... Just gets added in willy nilly.

Lisa

> Hello,
> 
>           I work in an oil refinery that has many units & I 
> have to send out monthly training material and I would like 
> to know if any one could give me an idea of how to accomplish 
> the following:
> 
> *I have a list of documents in excel with the columns being 
> the month distributed.=20
> 
> *Some people receive some documents that are related to a 
> certain unit (broken out by rows in excel).
> 
> *Each Doc I also have to type up a cover sheet for each that 
> has the persons name on it, the name of the document & some 
> other info.
> 
> *I also have to attach a generic document to each document 
> from the excel spreadsheet.
> 
> =20
> 
> Is there a way I table can be created to make things more 
> automated by printing each in order and attaching the correct 
> name to each of the coversheets?  I have to send thousands of 
> these out per year, some people receive a few of the 
> documents but most receive a handful.  There is a designated 
> list of who should be receive the documents.
> 
> =20
> 
> I appreciate any help.
> 
> Tiffani S.

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.12/655 - Release Date: 28/01/2007
13:12
 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: