Kaitlyn has attended:
Excel Intermediate course
Excel Advanced course
Mail merge from Excel to Outlook
How can you create an email mail merge using an excel spreadsheet as the source?
RE: Mail merge from Excel to Outlook
Hi Kaitlyn, thanks for your query. The answer depends a lot on the situation and there are several possible solutions. Do you want to mail merge into the content of an email or send 100 emails out using a list of addressees in an Excel spreadsheet? If the latter, you need to import the address list into Outlook to create an email group and then use that to email to the addressees. On the other hand, if it's the content you want to merge from Excel, the body of an email can be an HTML document. You could carry out a mail merge to Word and then save the documents out as HTML documents, using them as the body of your emails.
I hope this helps, but if you've got any more information do let me know.
Anthony