You can't do it out using the out-of-the-box MailMerge, but a year or so
ago I checked the situation where you are using Outlook and Exchange
Server (that was probably Outlook 2003) and it may be possible to do
something using VBA - for example, if you use the stuff written by Doug
Robbins at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
and you have "Send As" or "Send As Delegate" permission for another user
account, then you should be able to set
objMailItem.SentOnBehalfOfName = "the Exchange user name you want to use"
And send the item.
The item does not necessarily appear as "a sent on behalf of" item. If you
have "Send As" permission, it appears as if it's from the user you
specified in SentOnBehalfOfName and there is no "on behalf of" - the same
is true if you fill in the "From"
<<
BTW - Do you know of any 3rd party products that will allow me to do email
merges with a MS-SQL Database using email addresses in the GAL?
I don't know of ny such products (although that doesn't mean very much). I
have had some success in using addresses in the GAL as a mail merge data
source (i.e. source of e-mail addresses) but suspect that the technique
only works if you have administrator privileges, and perhaps there are
other barriers. Post back if you think it's worth knowing more, but maybe
you could say something about what you need to get from SQL Server (i.e.
if you are getting address info. from the GAL, and other data from SQL
Server, is it "peruser" data (in which case you need something that can
link the two) or do you want to store generic body text or some such in
SQL Server?
--
Peter Jamieson
http://tips.pjmsn.me.uk
Greg Hines said:
Hi Everyone,
I'm using Outlook/Word 2007 with Exchange 2003.
Our IT department has setup my emails so I can Send on behalf of another
email address. eg: sales[at]company.com instead of using my email
address.
Is it possible to do email merges and Send on Behalf of another user
instead of my default email address using Word 2007 or another third
party product?
TIA
Greg