How to customize the subject line in Mail Merge Toolkit for Outlook

Once you have used the acclaimed Word Mail Merge feature over the course of your mailing duties, whether on a daily basis or infrequently – there is no turning back. Literally no other out-of-the-box Microsoft Office tool offers you so many benefits for mass mailing with so little mouse-clicking involved and with such vast improvement of almost every aspect of the resulting letters. Its renowned personalization possibilities utilize the so-called “macros” (a placeholder word that exists only to be replaced with an actual recipient-specific value from a data-source). The product’s versatility and overall ease of use has secured it a firm place among the top-flight productivity tools for professionals in the field.

However, despite being a proven ally of many personalized mailing warriors, there is always space for more weapons on the rack. One such feature is the subject line customization, conspicuously missing in Word Mail Merge. While you can adequately solve this issue using generic subject lines, every now and then a significant benefit from personalize subject lines arises, as it will make the messages more attractive to end recipients, save you time, and, most importantly, ensure that the email catches the eye at a much higher rate. Who would ignore an email after seeing their unique and relevant data in the subject line?

In other words, customizing your subject line in Mail Merge can enable a whole new layer of quality mass mailing – which is always handy, and sometimes critical, since in some scenarios a subject line is even more important than the body of the letter itself.

In order to address this and other limitations of the Mail Merge function, the fine smiths at MAPILab have forged the Mail Merge Toolkit – a third party add-in that quietly integrates with Office as a certified COM Add-in, introduces many sought-after mass mailing features to Word, and seamlessly complements your regular workflow, rather than disrupting it with unfamiliar user interfaces. Once installed, the add-in is placed alongside its precursor:

Mail Merge addin in Outlook

The solutions are similar to each other visually, as well:

Mail Merge addin window

The principle behind the subject line customization here is the very same that fuels the regular “merge fields” in Mail Merge – the macros! Basically – a mere pointer to some place in your data-source where a certain piece of personal recipient’s data is stored. Let’s explain the whole idea in the following everyday example.

A mailing campaign for Acme, Inc. is ready for launch. The data-source is an Excel spreadsheet containing a list of the online catalog visitors who displayed an interest in a particular line of products. The goal is to inform the prominent visitors, whose names are known because of the website’s registration feature, of new products added to the product line in which they are interested:

Source for mail merging

Note: Outlook Contact fields could, naturally, also be used for customizing a subject line, but an external data-source allows for more scenarios, and therefore is more interesting to use as an example

While we leave the actual body of the letters to one’s imagination, noteworthy are the fields we can work with. Let’s say our interest is focused on having a potential customer’s name and the product type in our customized subject line. Those fields, then, are “Title/Gender”, “LastName”, and “ProductLine”. Good. Let’s craft our personalized subject line by clicking the respective ‘more’ button, and inserting each macro at a certain point along with the campaign words:

Outlook message subject customization

That’s it – the subject line customization is done!

Customized email subject in Outlook

When the letter reaches the intended recipients, they will notice a refreshing change from the usual Inbox stream, and be surprised at the effort and care taken to discover a new customer.

25 thoughts on “How to customize the subject line in Mail Merge Toolkit for Outlook

  1. I there! I’m currently using the free trial for the toolkit – will purchase when 30 days are up.

    However, I’m getting an error message when I try to finish the merge and send the emails. It says “The system cannot find the file specified” message along with an ERROR unable to send notice. Is this because I’m trying to use the toolkit for something that doesn’t come with the free version or is there something I can do to fix this?

    If it helps, it also says:
    File: UtilsCOM.cpp
    Line: 248

    I’ve tried changing the format of the email, making sure my data file is accurate and working, rebugging the toolkit, but the same error message keeps popping up and I can’t send them at all.

    1. Hello Rea, thank you for your question.
      Please install the most recent version (that error message was known with the previous one):
      https://www.mapilab.com/files/mail_merge_toolkit.zip
      If you used to install as Administrator, please select “For enyone who uses this computer (all users)” in the 3rd Installation Wizard step – please see my screenshot:
      https://www.mapilab.com/blog/wp-content/uploads/2015/06/1454.jpg

      If the issue reoccurs with the new version, please enable detailed logging (switch to “Verbose Info”), like in my screenshot:
      https://www.mapilab.com/blog/wp-content/uploads/2015/06/1679.jpg
      Once the issue is recreated – please switch logging back to None.
      And please contact us in our Trouble Ticket system with your log files:
      https://www.mapilab.com/users/reg_profile.html

  2. Every time I get to the end of the mail merge, it brings up a box that says “Error: “Invalid pointer” File: MailSenderClient.cpp Line: 282 Method:MailSenderClient::CreateOutlookSession

  3. Hello,

    We appreciate your interest in MAPILab products.

    This error message indicates that the add-in is disabled in Outlook. In order to resolve this issue, please enable Mail Merge Toolkit as follows:

    1) In Outlook 2010/2013/2016, navigate to “File -> Options -> Add-ins”;
    2) You can see the “Manage [COM Add-ins] Go…” control down below. The [COM Add-ins] part is switchable. Please click it and switch to “Disabled Items” so the control would resemble the “Manage [Disable Items] Go…” scheme.
    3) Click the “Go…” button.
    4) On the resulting window you should see the OutlookSenderAddin.dll file. Please enable it by highlighting it and clicking the “Enable” button.
    5) Next, please return to the “File -> Options -> Add-ins” window.
    6) Click the “Go…” button when the [COM Add-ins] item is switched.
    7) Locate the add-in in the add-ins list, and put a checkmark beside it to enable it. Click “Ok” and see if the issue has been resolved.
    8) If the issue still persists, please try restarting Outlook after steps 4 and 7 for the changes to apply.

    If there was no OutlookSenderAddin.dll file, please remove the checkmark in the 7th step instead, and retry the procedure from the start.

    For more technical support, please proceed to the Trouble Ticket area, as the comment section is not convenient for exchanging license information and files:

    https://www.mapilab.com/support/ticket.html

    Sincerely yours,
    Ivan.
    MAPILab Support Team.

    1. Hello Ben, thank you for your question.
      Our products are merely with the Microsoft software compatible (Windows OS and Microsoft Office for Windows…).
      We appreciate your interest in our software very much, but unfortunately, are not going to work on any software for the Macintosh company products within nearest future.
      We believe there should be similar solutions (produced by Apple or their partners) for the Macintosh software.

  4. Hello,

    I’d like to use an if/or type solution in the subject field. If there is a nick name, use it, if not, use the first name.

    Is there coding to use this? I have it working properly in the body of the mail merge but cant figure it out for the subject line. Thank you!

  5. Hello Brian, thank you for your question.
    Unfortunately, such nested statements are not supported in the subject line.
    If your recipients’ records in the data file contain either nickname, or firstname – you can add both fields to the subject: the add-in will paste the data from the field, i.e. if the field is empty – it will add empty value (space).
    We will apreciate your further questions.

    1. Could you create another column in your spreadsheet and have excel run your IF statement there? Then use that column for first name and you’ll have the best choice./dd

  6. Hello,

    Do you have an example of how to do this using outlook contact fields? I have played around with it, but have not been able to make it work.

    thanks

    1. Hello Dan, thak you for your question.
      Our add-in is the extension of the regular Mail Merge feature in Microsoft Office. Using Outlook Contacts is supported both by Mail Merge and by our Toolkit for it, and you can start your mailing directly from Outlook Contacts – and select them at the very first step:
      https://support.office.com/en-us/article/Use-Outlook-contacts-as-a-data-source-for-a-mail-merge-4cfcf038-1bc4-4a73-b5e3-a3303302db13?ui=en-US&rs=en-US&ad=US&fromAR=1
      We will be glad to answer all your further questions about our add-in.

      Regards,
      Olga

      1. Thank you for your question !
        Yes, please see in my screenshot: in the “Subject line” field, you can type your text, and also add your data fields from the data source – and custom values will be added to the subjects of your messages.

  7. Hi! I purchased this and tried to use it for the first time but I encountered an error. Now I would like to do it again but the “Merge & Send” is not there.

    1. ps: you may need to enable the app in Outlook as well – the menus are just the same like in Word, component name in Outlook COM Add-Ins is “Outlook SenderAddin”.

  8. i have tried this a few times, but in the emails it just sends out what is typed in for example the email received will have FIELD”First Name” in the subject line as opposed to the actual first name. Is there something that might be disabled or anything else i can try?

    1. Hello Dan, thank you for your message.
      That issue may occur if the field is used from the previous mailing and not refreshed.
      Please remove and then add the field to subject line before clicking on “OK” and starting mailing.
      To exclude issue with connection ro the data source, please add that data source field to your document as well – and in the 5th step (Preview of the regular Mail Merge Step by Step Wizard), please switch between several messages, just to make sure the data is replaced correctly. You will be able to remove that field later before sending message.
      If the issue reoccurs – please contact us in our Trouble Ticket system:
      https://www.mapilab.com/users/reg_profile.html

  9. I’m looking at buying your mailmerge product. Can you advise if I can cc someone in a mailmerge that also has an attachment?

    Also is there a maximum number of people I can mailmerge?

    Thanks

    David

    1. Hello David, thank your for your questions.
      CC-recipient will get a copy of the message addressed to the TO-recipient: e.g. if you have 10 recipients, and type nick-parker@mail.com to CC, Nick will get all 10 copies of personal messages to different recipients.
      But with an Excel file, you can add custom field for CC-recipients, and personalize them as well:
      e.g. a copy of your message to Mary will go to her teacher, a copy of message to Tom will go to his boss… Main recipients are Mary and Tom, and custom CC-recipients will receive their custom copies of messages to Mary an Tom, with custom attachments for Mary and Tom.

      Full registered add-in version does not impose any limit on the number of messages – it will generate messages for all TO-recipients (with CC-recipients if you need) and place them all to Outlook Outbox. Limitations may be applied here by mail server – ISPs often limit outgoing messages per hour or day, and you will need to elaborate this question by your ISP or administrators. The trial version of Mail Merge Toolkit will generate messages for 50 recipients from your list – and then correctly show its trial notification.

  10. I there! I’m currently using the free trial for the toolkit – will purchase when 30 days are up.

    However, I’m getting an error message when I try to finish the merge and send the emails. Is there something I can do to fix this?

    If it helps, it also says:
    Error : Invalid Pointer
    File: Mailsenderclient.cpp
    Line: 383

    I’ve tried changing the format of the email, making sure my data file is accurate and working, rebugging the toolkit, but the same error message keeps popping up and I can’t send them at all.

    1. Hello,

      We appreciate your interest in MAPILab products.

      This error message indicates that the add-in is disabled in Outlook. In order to resolve this issue, please enable Mail Merge Toolkit as follows:

      1) In Outlook 2010/2013/2016, navigate to “File -> Options -> Add-ins”;
      2) You can see the “Manage [COM Add-ins] Go…” control down below. The [COM Add-ins] part is switchable. Please click it and switch to “Disabled Items” so the control would resemble the “Manage [Disable Items] Go…” scheme.
      3) Click the “Go…” button.
      4) On the resulting window you should see the OutlookSenderAddin.dll file. Please enable it by highlighting it and clicking the “Enable” button.
      5) Next, please return to the “File -> Options -> Add-ins” window.
      6) Click the “Go…” button when the [COM Add-ins] item is switched.
      7) Locate the add-in in the add-ins list, and put a checkmark beside it to enable it. Click “Ok” and see if the issue has been resolved.
      8) If the issue still persists, please try restarting Outlook after steps 4 and 7 for the changes to apply.

      If there was no OutlookSenderAddin.dll file, please remove the checkmark in the 7th step instead, and retry the procedure from the start.

      For more technical support, please proceed to the Trouble Ticket area, as the comment section is not convenient for exchanging license information and files:

      https://www.mapilab.com/support/ticket.html

      Sincerely yours,
      Ivan.
      MAPILab Support Team.

  11. HI There,

    Im still using the trial and would like to check with you before purchasing.
    I have several email account in my outlook; a personal email and team email.
    I would like to send multiple email through the team email to the multiple recipients through the mail merge toolkit.
    I have set the team email as default email, however, after mail and merge under mail merge toolkit, it is still send from my personal email instead of team email.
    Is there anyway to fix this issue?

    Also, how long is the validity of each licence purchases?

    1. Hello JYLim, thank you for your question.
      Please test with the selection of the account manually.
      Another possible workaround for this kind of issues is creation of a new profile with single account: http://support.microsoft.com/kb/829918
      Sending through different accounts may depend on the mail server configuration. If you have several accounts in your currentle used Outlook profile, and get their selection while sending thought Mail Merge Toolkit (if “use default is disabled”) – our add-in will save your account selection in message properties. You can check that if you stop your outgoing mail: either click “Work Offline” on the “Send/Receive” ribbon, or disable “Send immediately is connected” in Outlook menu File-> Options-> Advanced-> and scroll to “Send and Receive”. Your messages will stack in Outbox, and you will see which account is specified there. If the account is correct, but messages finally are sent through another account – probably, your mail server administrators will be able to comment on this. If they conclude the issue occurs on our side – please contact us in our trouble ticket system with the details.

    2. >> Also, how long is the validity of each licence purchases?
      According to the License Agreement [https://www.mapilab.com/purchase/license.html], you can use registered programme version as long as you wish, but in a year after purchasing license, our customers are offered:
      - either to keep the existing programme version (if they believe they will not upgrade their Microsoft software configuration, and also believe any future system update doesn’t affect their system functionality critically);
      - or – to extend period for getting free software updates on advantageous terms, i.e. to renew the license for the 50% of the original license costs within the 13th month.

Leave a Reply

Your email address will not be published. Required fields are marked *


7 − = five

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>