[mso] Re: FW: Excel-Distribution help request_thnx :VSMail mx3

Tiffani,

You will need to use VBA to automate your process.  I don't know the =
Excel side of things well enough to help you out in that, but this =
sounds like it may be a great application to move into Access.  Your =
data sounds as if it would be better in a relational database rather =
than a flat file.

Assuming you are using Outlook as your email application, you can do a =
lot with VBA.  You could actually use it to open a new email, attach the =
correct documents, populate all the necessary fields in your email and =
then send it (depending on your version and security settings a single =
click may be required here) for each of the people receiving documents.

James

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Scott, Tiffani D.
Sent: Tuesday, January 30, 2007 6:51 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] FW: Excel-Distribution help request_thnx :VSMail mx3


No one has any ideas?

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Scott, Tiffani D.
Sent: Monday, January 29, 2007 11:30 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel-Distribution help request_thnx

Content-Type: text/plain;
        charset=3D3D"us-ascii"
Content-Transfer-Encoding: quoted-printable
 =3D3D20

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.=3D3D20

*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.

=3D3D20

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.

=3D3D20

I appreciate any help.

Tiffani S.




-- No attachments (even text) are allowed --
-- Type: image/jpeg
-- File: image001.jpg
-- Desc: image001.jpg


*************************************************************
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
*************************************************************
*************************************************************
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
*************************************************************
This message contains information that may be confidential and is =
intended only for the use of the=20
person/persons identified and intended as the recipient. If you are not =
the intended recipient, any=20
disclosure, copying, distribution or use of this information by anyone =
else is strictly prohibited.
If you have received this in error, please contact the sender =
immediately and delete the message=20
from your computer.
*************************************************************
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: