richard_west
asked on
Email Merge but need to change Sender During Merge
I need to do an Email merge using Word 2003 from a data file. In addtion to the "to" email address and other information, one of the fields in the data file will contain the Name, and another the email address that I would like the email to APPEAR FROM. My company wants these emails to go out to each customer, but appear as if the customers' Account Manager was the person sending the message - so any replies are properly directed.
Rather that send each Account Manager the Word file, and a subset of the data file for them to preform the merge on, I am looking for a way for me od do this from one computer.
Thanks!
Rather that send each Account Manager the Word file, and a subset of the data file for them to preform the merge on, I am looking for a way for me od do this from one computer.
Thanks!
Joanne M. Orzech
Never tried it, but can't you just add a field for sender?
ASKER
Not that I can find -- that is exactly what I am trying to do.
Can't you just add a field for sender in your data file?
ASKER
I have the field in my data file.
What I do not see if how to make Word _use_ the sender field, and make the email appear to come from that person when completing the merge. I want the email message to have the return address of the sales rep -- I have this address in my data field.
However, during the merge, Word sends all message through the Default account in Outlook. So all mail appears to come from me. I do not see an option in Word to tell it to use a data field and the "sender address" or "reply address".
What I do not see if how to make Word _use_ the sender field, and make the email appear to come from that person when completing the merge. I want the email message to have the return address of the sales rep -- I have this address in my data field.
However, during the merge, Word sends all message through the Default account in Outlook. So all mail appears to come from me. I do not see an option in Word to tell it to use a data field and the "sender address" or "reply address".
OK - I do understand - sorry to be so thick. Unfortunately, the PC I am working on right now for some reason doesn't want to send mail from Word...so I'm afraid I'll have to get back to you later. In the meantime, perhaps some other experts will pop in and help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks JOrzech - so far that is the only way I have found as well.
I will go ahead a close the question.
I will go ahead a close the question.
Thanks Richard - sorry I couldn't have provided a better solution... maybe it's a built-in function to stop spammers.
Oh well - you win some, you lose some...
Oh well - you win some, you lose some...