Link to home
Start Free TrialLog in
Avatar of mike2401
mike2401Flag for United States of America

asked on

Mail Merge w/ Attach & "Send As" & Excel Data Source & GAL Dist. List

Am I asking too much?

I need to do MAIL MERGE:

1) The customer name/email data is in Excel,
2) Each customer must be BCC'd
3) In the same message, I'd like to copy all employees.  They are stored in our Exchange 2007 GAL: "All Employees" Distribution List.
4) I need to attach a PDF
5) I need to use the Exchange Permissions so it appears that it was sent by the President of our company, and not is secretary.
6) All customer data must stay within our company (may not use an 3rd party newsletter service)
7) I'd like 1 message per person because I believe outlook doesn't like 1 message addressed to 600 people (plus, I have the sense that it reduces the risk of an accidental disclosure of the entire list should a mail server burp out a failure notice to the entire list or something).

Any ideas would be VERY MUCH APPRECIATED,
Thanks,
Mike
Avatar of mike2401
mike2401
Flag of United States of America image

ASKER

One more:
#8: because the recipients change all the time, I don't want to import the excel data or gal: distribution list into a stand alone application (I don't want to do double-maintenance of the records).

Thanks again for any thoughts,
Mike

ASKER CERTIFIED SOLUTION
Avatar of mike2401
mike2401
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial