Mail Merge Help Needed Please!

[tonylpcs@yahoo.co.uk]

Hi Everyone,

can anyone help me,

i use excel as my database and mail merge to Word, but when i bring a field through, the format is different,

for example if im bringing through a date, on the excel sheet in in put "31/05/08 and it shows in the cell as "31 May 2008" but when i bring it through to a word document the for is completly different and shows as "05/31/08"

and if i bring through money amounts it does not show the £ sign or the full amounts

can anyone help me!

thanks

Tony

 

[riaz]

Hi tony

I'm no expert at word, so my quick and dirty solution is to stick in an extra column next to the date, convert all your dates to text, and use that in your word doc. Works for me.

As for the amount, once again, extra column, convert to text and stick a £ sign before it in the converted column.

As I said, someone may come up with a more elegant solution, but just to get you up and running, this works for me.

Hope this helps.

 

[Domski]

Hi,

Have look here:http://wordprocessing.about.com/od/usingmailmerge/qt/exceldde.htm

Should solve your problem.

Dom

 

[Domski]

By the way, I'd ask one of the admins to change your username from your e-mail address to something more anonymous. It's only a matter of time before some nasty little program picks it up and you end up with a deluge of spam.

Dom

 

[riaz]

Thank you Dom. My knowledge increases by leaps and bounds every day.

Kind regards

 

[Eric Golf]

Hi,

Great link Domski, why didn't I post a thread about this last month

Eric