rodtt
07-14-2013, 01:28 PM
Hi everybody!
I'm in the process of finishing an excel spreadsheet, but I'm having a difficult time with mail merge on word. I made a macro on excel to open my word document and there are two problems happening:
1) Everytime I open my word document, I have to go through the process of selecting recipients and choosing again my excel source file. Maybe I'm missing something in the process, but the fields remais with place holders, like <<Name>>, for example.
2) Date Merge Fields are not retaining excel format.
2.1) I live in Brazil, and date format here is DD/MM/YYYY, but when merged on word it changes do MM/DD/YYYY.
2.2) One field is formated as MM/YYYY, but on word it changes to MM/DD/YYYY
Both my files, spreadsheet and word doc, are in a folder on desktop.
I'm using office 2010.
Thanks!
I'm in the process of finishing an excel spreadsheet, but I'm having a difficult time with mail merge on word. I made a macro on excel to open my word document and there are two problems happening:
1) Everytime I open my word document, I have to go through the process of selecting recipients and choosing again my excel source file. Maybe I'm missing something in the process, but the fields remais with place holders, like <<Name>>, for example.
2) Date Merge Fields are not retaining excel format.
2.1) I live in Brazil, and date format here is DD/MM/YYYY, but when merged on word it changes do MM/DD/YYYY.
2.2) One field is formated as MM/YYYY, but on word it changes to MM/DD/YYYY
Both my files, spreadsheet and word doc, are in a folder on desktop.
I'm using office 2010.
Thanks!