Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Mailmerge using generic email address ?

Posted on 2013-02-05
13
Medium Priority
?
808 Views
Last Modified: 2013-02-13
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
0
Comment
Question by:kriiis
  • 7
  • 5
13 Comments
 
LVL 33

Expert Comment

by:Paul Sauvé
ID: 38857342
Is it only ME, or is this question really not clear?
0
 

Author Comment

by:kriiis
ID: 38858212
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
 

Author Comment

by:kriiis
ID: 38858215
Generic email address to be shown which is actually configured in my outlook as common mailbox.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
LVL 77

Accepted Solution

by:
GrahamSkan earned 300 total points
ID: 38858981
Have you tried changing the default mail address in Outlook to the generic one?
0
 

Author Comment

by:kriiis
ID: 38860295
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
 
LVL 77

Expert Comment

by:GrahamSkan
ID: 38860319
If so, it would have to be switched back after the merge.
0
 

Author Comment

by:kriiis
ID: 38860332
mean each and every time, user should switch betweent he different profiles ?
0
 
LVL 77

Expert Comment

by:GrahamSkan
ID: 38860376
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
 

Author Comment

by:kriiis
ID: 38861177
Nope, i dont know VBA code.

Do you think this is possible using vba ?
0
 
LVL 77

Assisted Solution

by:GrahamSkan
GrahamSkan earned 300 total points
ID: 38861566
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
 

Author Comment

by:kriiis
ID: 38865711
Ok, so no way to make it work...
0
 
LVL 77

Expert Comment

by:GrahamSkan
ID: 38866219
The main question is answered, but your further requirement for full automation is not possible.
0
 

Author Closing Comment

by:kriiis
ID: 38886484
it doesnt respond really my question but its an option when we don't have other solution
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article lists the top 5 trialware OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their Exchange server is no longer available or other critical issues with Exchange server or impo…
As a Microsoft Exchange user, you must have known the importance of an Offline storage table (OST) file. It is nothing new for an Outlook user to be dependent on a .ost file during a server break down or a problematic Internet connection. In such a…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

580 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