mailmerge

  1. A

    Changes in macro for mailmerge

    Hi, I am new to VBA and I tried the following VBA code which I found from a website. It is working, but the problem is the individual document format is different from that of the mailmerge template. But I want the same format as it is the template. Option Explicit Sub...
  2. V

    Mail merge date anomaly

    Hello oh founts of all excel knowledge... I'm merging from Excel 2007 to Word 2007. I have two date fields - Start Date and Leave Date. Both are formatted exactly the same in the Excel Spreadsheet: Start Date 01 July 2011 Leave Date 11 May 2012 and both have exactly the same switch in the...
  3. G

    Mailmerge in UK Date Format??

    OK. Please read this carefully before replying as I know how to mail merge dates but for some reason its not working properly. On a spreadsheet I have a list of dates that mail merge to Word 2010, in order to invite people for interview. The dates merge as dates BUT seem to mess up. ie: if its...
  4. V

    Mailmerge with picture

    Good day sir. I have downloaded a copy of your program which is a mailmerge in excel without using word. i found it very good and interesting. however, i just don't know how i could "manipulate" that program to suit my needs. i wanted to make a layout. 1 page containing 5 back to back layout of...
  5. E

    How to import date field from Excel to Word?

    Using Microsoft Word Mail Merge, how do I import dates from a MS Excel Spreadsheet? Using the mail merge within MS Word, everything imports fine except dates. For example, my date of 5-22-10 in MS Excel turns into 40374 when it is imported into word. In Excel the date is formatted as a date. I...
  6. G

    Mailing each worksheet in a Workbook

    :confused:Hello I have 70-80 worksheets in my workbook, which I need to send to different receipients as an individual workbooks. My codes looks like below: Sub Mail_Every_Worksheet() 'Working in 2000-2010 Dim sh As Worksheet Dim wb As Workbook Dim FileExtStr As String Dim...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top