Software

Ask something
Question Locked

Microsoft Excel Pivot Table Merge

0 helpful
2 replies

by brian.morrison

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to know if an email merge can be created from a pivot table by sending multiple email recepients thier respective top-10 lists (which differ by email address recepient) to each address without sending them 10 emails (like a mail merge does in rows). The way the pivot table is built is the recepient items are in the ROW section, their top-10 items are in rows in the DATA section.

2 replies

by pd

Any replies to your request? I have been email merging and also want to send our customer's top 10 list without sending 10 emails. I have tested copying and pasting in a single cell (set as Memo field) in Access, but you cannot control how the columns will line up. I'm also seeing if Publisher will allow for the appearance in their customerized newsletter feature (see http://office.microsoft.com/en-us/publisher/HA101857621033.aspx ).
This can be a powerful way of automating dealer performance in emails of newsletters. Keep me posted.

This discussion is closed to new replies.