If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Office 2007: Word, Excel, Outlook Merge (Email)
I need to prepare an "email" mailmerge file in Word that will be integrated
with some data from an Excel file. I then want to merge the finished product with some contacts from Outlook and email out the individual emails. (I know you can do a mailmerge from within Outlook but I don't see a way to also merge data from Excel. I also know you can do a mailmerge from within Word and integrate data from Excel BUT I don't know if there is a way to integrate data from Excel into a Word mailmerge and THEN merge that with Outlook and send it out via email.) Help! |
#2
|
|||
|
|||
Office 2007: Word, Excel, Outlook Merge (Email)
You need to have the email addresses of the recipients in the mail merge
data source. That is probably going to mean exporting your contacts from Outlook and adding an email address field in the Excel spreadsheet that is populated with that data. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "ocean mist" wrote in message news I need to prepare an "email" mailmerge file in Word that will be integrated with some data from an Excel file. I then want to merge the finished product with some contacts from Outlook and email out the individual emails. (I know you can do a mailmerge from within Outlook but I don't see a way to also merge data from Excel. I also know you can do a mailmerge from within Word and integrate data from Excel BUT I don't know if there is a way to integrate data from Excel into a Word mailmerge and THEN merge that with Outlook and send it out via email.) Help! |
Thread Tools | |
Display Modes | |
|
|