98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Mail Merge into Word..
Excel Mail Merge into Word..
Resolved · Medium Priority · Version 2010 Featured
Shaun has attended:
Excel Intermediate course
Excel Mail Merge into Word..
I'm pulling text through from a different sheet to incorporate into an MS Word Doc. All data inputed into the doc somes through except the information which is pulled through via a formula from a different sheet? Help Please
RE: Excel Mail Merge into Word..
Hi Shaun
Thanks for getting in touch.
What you're proposing should work. The formula results should be dropped into your document as expected.
What is the formula that's causing the issue?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel Mail Merge into Word..
Thanks for the quick response Gary. Should work but it isn't!
The formula of the cells are simply =Design!AR2 etc...
This just pulls through a result of 0 in word. Despite being able to see the text in excel. There is quite a bit of text in these cells as it contains a build schedule?
Any ideas how to resolve this?
Many thanks,
Shaun
RE: Excel Mail Merge into Word..
Hi Shaun
Thanks for your reply. I wasn't able to replicate your issue, but after a little research I read about a potential flaw with this process.
Is the workbook open? Try having the Excel workbook open as you complete the Mail Merge. Apparently this keeps the data more 'current' than allowing Word to attempt to resolve the formula.
If this doesn't work, what is the data type you are trying to merge (e.g. text, dates, currency... etc)?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Turn Function tooltips on and offExcel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are! |