mike2401
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
#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