<div>
Is it possible to send it out through a PDF attachment ? Tks
</div>


Is it possible to send it out through a PDF attachment ? Tks

<div>
follow the mail merge in the thread <a href="http://www.statelibraryofiowa.org/ld/q-s/silo/e-mail/outlook/email-merge" rel="ugc">http://www.statelibraryofiowa.org/ld/q-s/silo/e-mail/outlook/email-merge</a><br />
<br />
However, my word file has company logo but it appear as two pages in recipient email. Any idea ? I have already used HTML format.
</div>


follow the mail merge in the thread http://www.statelibraryofiowa.org/ld/q-s/silo/e-mail/outlook/email-merge [http://www.statelibraryofiowa.org/ld/q-s/silo/e-mail/outlook/email-merge]

However, my word file has company logo but it appear as two pages in recipient email. Any idea ? I have already used HTML format.

<div>
Check out my article<br />
<a href="https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_17839-Mailmerge-using-Visual-Basic-MS-Excel-2010-and-MS-Outlook-2010.html" rel="ugc">https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_17839-Mailmerge-using-Visual-Basic-MS-Excel-2010-and-MS-Outlook-2010.html</a><br />
<br />
It is a vba script to do exactly what you want. <br />
<br />
I'll post the spreadsheet tomorrow.
</div>


Check out my article
https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_17839-Mailmerge-using-Visual-Basic-MS-Excel-2010-and-MS-Outlook-2010.html [https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_17839-Mailmerge-using-Visual-Basic-MS-Excel-2010-and-MS-Outlook-2010.html]

It is a vba script to do exactly what you want.

I'll post the spreadsheet tomorrow.

excel macro enabled spreadsheet with instructions

generic-email.xlsm

<div>
<div class="content wysiwyg-content">
We have a template and a Excel file with a list of username and email. We need to mail merge the two and send out through outlook . Any idea how to do this ?<br />
<br />
Tks
</div>
</div>


We have a template and a Excel file with a list of username and email. We need to mail merge the two and send out through outlook . Any idea how to do this ?

Tks

Bulk mail send in Outlook

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

An email client, email reader or more formally mail user agent (MUA) is a computer program in the category of groupware environments used to access and manage a user's email. A web application that provides message management, composition, and reception functions may internally act as an email client; as a whole, it is commonly referred to as webmail. Likewise, email client may be referred to a piece of computer hardware or software whose primary or most visible role is to work as an email client. Email clients can also have other systems, like calendars, notes and contact managers.

Email Clients

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.