Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Mail Merge - (NEXT) - Dynamics 365 Quote

(0) ShareShare
ReportReport
Posted on by 2

Hi All,

I just wanted to put this out there as I nearly lost my mind to this frustration!.

In the standard opportunity to quote, there is a button at the top that say - print for customer. (Awesome!) or so i thought. The default organisation template is basic to say the least and work if you are using all the default 'total' fields. You may also notice the the totals are all at the top of the document with the quote products below. But what if i want the totals at the bottom like every other quote layout i have ever seen?

From what i can tell when the mail merge runs its merges the quote product lines on the the template and where it see 'NEXT' ~(which is mail merge rule) it moves to the next opportunity product and therefore next line.

The problem i found is as soon as i created my own custom mail merge template and started using the 'Next' rule, the dynamic fields from quote product were there but anything from Quote vanished... almost like there was no data in the Dynamics 365 quote record! weird!

The other down side was if had 2 quote products in the my quote and 50 quote product lines in my template i had modify the completed mail merge in word before I could send it to the customer as i would end up with 48 blank lines.

I let the struggle begin... was i supposed to use 'Next', Next IF..... nothing seemed to work.

Until i fell on to this article..

www.powerobjects.com/.../how-to-create-a-microsoft-word-template-in-microsoft-dynamics-365

Specifically point 9

After this I completely dumped the print for customer button and used a document template instead!

I hope this helps someone.

Thanks

Bennyboy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Dynamics 365 general forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans