mailmerge

I have a spreadsheet as a .xls generated from a swimming carnival program. It gives me data in column A that looks like: <tbody> Appleby, Esmae - Female - Year: 7 - Comp#: - T - DOB: 14/03/2003 #73 Girls 12 100 Free Secondary Bonnyville Sarah - Female - Year: 7 - Comp#: - T - DOB...

Essentially, I would like to find a way to create 400+ bookmarks in a word document through mail merge or by some process with VBA. I've created a word document with several mail merge fields that create individual pages for U.S. States with some summary information. I need four of these fields...

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...

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...

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...

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...

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...

: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...