excel mail merge into
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777
STL

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Mail Merge into Word..

Excel Mail Merge into Word..

resolvedResolved · Medium Priority · Version 2010 featured Featured

Mon 22 Oct 2012, 16:23 replyReply Delegate Shaun said...

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

For upcoming training course dates see: Pricing & availability

Tue 23 Oct 2012, 13:29 replyReply Trainer Gary said...

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: 0845 5194 797
Best STL - http://www.microsofttraining.net
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

Tue 23 Oct 2012, 14:37 Edited on Tue 23 Oct 2012, 14:39 replyReply Delegate Shaun said...

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

Tue 23 Oct 2012, 15:04 replyReply Trainer Gary said...

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: 0845 5194 797
Best STL - http://www.microsofttraining.net
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

Fri 26 Oct 2012, 09:54 replyReply Delegate Shaun said...

RE: Excel Mail Merge into Word..

Thanks Problem now sorted. The way to make it work was to open excel first before opening the word document and linking. It was the current data issue.

Help greatly appreciated.

Shaun


 

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Training classes
London & UK

Live dates & prices »

On-site training

60-second quote »

E-Learning

From £99 · Call us »

Mailing list

Sign up for latest offers »

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.



Excel training
Course rating
4.7 stars - based on 25090 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom

info@microsofttraining.net

Resources

X

Search