Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there and welcome
To do this
Select the tab Mailings-> click the Start Mail Merge button-> Step by Step Mail Merge Wizard…
The Task Pane panel will open on the right side of the document to choose the document type. Here select “E-mail messages”.
"Select from Outlook contacts".
As you can have multiple Contacts folders in Outlook you need to select the actual folder which we will be using by pressing "Choose Contacts Folder".
After selecting the Contact folder of your choice you could be presented with the "Choose Profile" dialog from Outlook. If you don’t know this dialog there is probably one selection in the drop down list anyway or set to the correct default so simply press OK.
Word now opens the "Mail Merge Recipients" dialog where you can specify which contacts to send to. While the dialog in Word 2007 has been improved to allow for more selecting and filtering options than in previous versions of Word, personally I think it’s still a bit clunky and can be slow when you have a lot of contacts as it also refreshes the screen after pretty much every action. However, the "Find duplicates…" feature is quite handy especially when you want to use the entire Contacts folder for your mail merge.
After selecting the recipients, the next step is to write your message. The Mail Merge Wizard already shows you some variables you can use.
The next step allows you to preview all the emails you’ll eventually be sending.
You can press "Electronic Mail…" to set the final options before mailing your message To: Email_Address Subject line: Your personal information
After setting the options, pressing OK will direct start sending the emails.
Let me know please if you have any difficulties
I don't think you've read my question carefully. I'm trying to do something beyond an ordinary merge 1-address-at-a-time merge - specifically, for EACH message I am going to send, I need to be able to assign several addresses to the To field, several addresses to the cc: field, and one address to the bcc: field. Is there a way to control this in Office? Or is there perhaps an add-in that you would recommend?
I have to leave, but will be interested in your reply. Many thanks!
ok, what you are going to need to do is export your contacts from outlook to a CSV file
You then open this CSV in Excel and put all the email addresses into the primary email seperated by a ;
this way all the email addresses are in one cell
you then make a new address box in Outlook and import the CSV file into it
and perform the merge from this
Let me know if you have any difficulties please
Ok - I get that this is not the best forum for this involved a question. And I now understand that you're not getting paid much for the exchange. But I'd like to try one last time, since I did pay $39 for this, and if there's really something useful in your response, I'd very much like to get it. Exporting to csv I get. But are you suggesting I essentially put all the addresses in the To: XXXXX XXXXX send a signle e-mail to multiple addressees? If you're suggesting something different, then I do need further explanation. What does "make a new address box in Outlook" mean? And how would I import the CSV file into it? And how would I perform the merge from whatever that thing is? Thanks for your patience!
and note I only get paid when you click Accept
now what I meant is this
put all the different contact addresses in to main address list in the exported Excel list
seperated by a ;
eg: joe @ me.com;Joe @ work.com; Joe 2 home.com
once done, them make a new profile in Outlook by click Start, Control Panel, Mail
Go to profiles, and add a new one
it can be any email adderess ect, we just want a new address book
Then on the new profile, click File, Import, and import the CSV file into the address book
this will have the contact with the multiple email addresses in the main email address
you can then do the mail merge based on this new address book (contacts)
does that make sense?
Ah - yes. Now I do get it. Thanks very much, Richie. Best, JC
your very welcome!
please remember to click Accept
and take care