Mail merge DDE issue

Good Day,

I am trying to create a mail merge using word and pulling from an excel document,

When i select the document I want to bring my information from and it asks me to confirmed the data source,

If I select OLE DB Database Files,

it works fine (unfortunately it doesn't have the same format from excel)

So the suggested fix is to select MC Excel Worksheets via DDE (*.xls)

However when doing so, my headers don't align with my columns information,

as if the headers are shifted one column to the right while the information stays in its current location,

so this...

OLE

name phone zip
Max 111-111-1111 12345
Jane 222-222-2222 54321

looks like this in DDE....

name phone zip

Max 111-111-1111 12345
Jane 222-222-2222 54321

The excel is saved as a macro enabled sheet, does that have anything to do with it?

When asked in DDE to select a sheet ... i only see "entire spreadsheet" but that only will read the first sheet, is there any way to choose which sheet?

Thanks for your time,

FWIW, the 'correct' way to manage the output formatting in a mailmerge is via field switches, not by switching to DDE. Whilst using DDE preserves the formatting in the data source, for anything different you'd need to either change the source format, use extra fields for different formats, or use field switches - the same as you can with the OLE DB default. The most commonly-needed formatting switches were discussed just a few days ago in this thread: http://www.excelforum.com/word-forma...-in-excel.html