Mailmerge using generic email address ?

Hi,

I use mailmerge function in word. I have set of email address in excel sheet, and i have a letter format in word , i use mailmerge to fetch address from the excelsheet and send via mail outlook.
My question is, by default it fetches my email address but i want to use the generic email id so that receiver see only that mail.
My outlook is configured with my mailbox and added the generic account as secondary one.
Any tips to fix this ? See also the screenshot, in word it gives only " To".
mailmerge.JPG
kriiisAsked:
Who is Participating?
 
GrahamSkanRetiredCommented:
Have you tried changing the default mail address in Outlook to the generic one?
0
 
Paul SauvéRetiredCommented:
Is it only ME, or is this question really not clear?
0
 
kriiisAuthor Commented:
The excel sheet contains the receiver's email address.
Using mail merge ( mailing format ) function in word I send the letter to all the email address referred in excelsheet.
Here the receivers receive mails from my email address. I don't want this. But I want the generic email id
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
kriiisAuthor Commented:
Generic email address to be shown which is actually configured in my outlook as common mailbox.
0
 
kriiisAuthor Commented:
Nope...

the problem is the primary mailbox will become secondary, then when user sends email from the own mailbox goes to generic account sent item.
0
 
GrahamSkanRetiredCommented:
If so, it would have to be switched back after the merge.
0
 
kriiisAuthor Commented:
mean each and every time, user should switch betweent he different profiles ?
0
 
GrahamSkanRetiredCommented:
If you have two accounts, you will have to manage them if you sometimes want to use one and sometimes the other.

I'm not very familiar with the Outlook object model, but it might be possible to use VBA to automate it. Do you know how to use and program VBA code?
0
 
kriiisAuthor Commented:
Nope, i dont know VBA code.

Do you think this is possible using vba ?
0
 
GrahamSkanRetiredCommented:
It doesn't look like it. I found this discussion where an Outlook MVP says that it isn't possible.
http://www.pcreview.co.uk/forums/vba-switch-default-email-account-t1839774.html
0
 
kriiisAuthor Commented:
Ok, so no way to make it work...
0
 
GrahamSkanRetiredCommented:
The main question is answered, but your further requirement for full automation is not possible.
0
 
kriiisAuthor Commented:
it doesnt respond really my question but its an option when we don't have other solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.