Solved

Email Merge but need to change Sender During Merge

Posted on 2004-09-21
8
743 Views
Last Modified: 2008-02-26
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!
0
Comment
Question by:richard_west
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 12122343
Never tried it, but can't you just add a field for sender?
0
 
LVL 1

Author Comment

by:richard_west
ID: 12122909
Not that I can find -- that is exactly what I am trying to do.
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 12123572
Can't you just add a field for sender in your data file?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:richard_west
ID: 12123618
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".
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 12124206
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.
0
 
LVL 37

Accepted Solution

by:
Joanne M. Orzech earned 500 total points
ID: 12128876
OK - I've tested it a little bit... the only way I can find to change the sender is if you have an email account set up under that person's name in Outlook (Tools, Accounts, Mail, Add).  Sorry richard_west.  Can't find any other way to change the name of the person sending the message.  I don't think it can be done.


0
 
LVL 1

Author Comment

by:richard_west
ID: 12129249
Thanks JOrzech - so far that is the only way I have found as well.

I will go ahead a close the question.
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 12129316
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...
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Changing Comments author in Word 2010 10 41
word 2016 1 40
How to open Microsoft Word 2013 in edit mode from the server 16 98
auto correct in word  VS outlook 5 27
Introduction Authors who set out to write any sort of lengthy piece for online submission—be it a long question or comment on a technical form, an article, or a substantial blog entry—often find it useful to work up a draft in an editor other t…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question