Merging Excel Date into Email Message

  • Thread starter Thread starter Becca
  • Start date Start date
B

Becca

I have several LARGE spreadsheets that I receive each month from an
outside vendor.
There are multiple rows that relate to one "person." I need to send
the related to that one person in email to that person. Clear as
mud :)

I understand how to do the merge from Excel to Outlook (with the use
of Word), but what I am unable to understand is how to have each
person "grouped" so that their information is seen as one record in a
merge.

I think the best way is through a Pivot Table, but not sure this would
work with a merge.

Any suggestions that I can investigate.

Thanks!
 
Sounds like you need a macro that for each person, rips through each
spreadsheet and copies the data into another spreadsheet and sends
that to the user.

VBA programming is required.

Regards,
Tom Bizannes
Excel Development
Sydney,Australia
http://www.macroview.com.au
 
Hi,

Since you haven't shown us what your data looks like its hard to make a
suggestion. If your data were laid out as below there is a quick way to fill
in the missing names.

Fred stuff
more stuff
even more stuff
Marsha stuff
more stuff
good stuff
better stuff
best stuff
....

So please show us a sample of the data layout.
 
Back
Top