kriiis
asked on
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
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
Is it only ME, or is this question really not clear?
ASKER
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
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
ASKER
Generic email address to be shown which is actually configured in my outlook as common mailbox.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
the problem is the primary mailbox will become secondary, then when user sends email from the own mailbox goes to generic account sent item.
If so, it would have to be switched back after the merge.
ASKER
mean each and every time, user should switch betweent he different profiles ?
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?
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?
ASKER
Nope, i dont know VBA code.
Do you think this is possible using vba ?
Do you think this is possible using vba ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, so no way to make it work...
The main question is answered, but your further requirement for full automation is not possible.
ASKER
it doesnt respond really my question but its an option when we don't have other solution