Outlook Mail Merge without duplicates

[Burning_Ranger]

If I have a CSV like...

Person1, Time1, Email1
Person2, Time2, Email2
Person1, Time3, Email1

I want to email merge and create two emails rather than 3. There
should be only one email for Person1 with Time1 AND Time3 rather than
two separate emails for Person1, one with Time and one with Time3. Is
this possible to do?

 

[Roady [MVP]]

Easy, import the csv-file into Excel and filter out the duplicates.

 

[Burning_Ranger]

Easy, import the csv-file into Excel and filter out the duplicates.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

http://www.msoutlook.info/
Real World Questions, Real World Answers

I need the duplicates. I don't think you understood the question. When
I do a mail merge, each row on the spreadsheet is a new mail merge
document. However what I want is one mail merge for each Person with
ALL their times. So if 1 person did 20 shifts a month, I don't want to
send them twenty emails with every single individuals shift, but
rather I want to send them 1 email with all two shifts in the email.

 

[Roady [MVP]]

No, you currently don't have the correct format of your csv-file then. It
needs to be formatted with the following columns for that to work;
Name | Email | Time1 | Time2 | Time 3

Easy, import the csv-file into Excel and filter out the duplicates.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

http://www.msoutlook.info/
Real World Questions, Real World Answers

I need the duplicates. I don't think you understood the question. When
I do a mail merge, each row on the spreadsheet is a new mail merge
document. However what I want is one mail merge for each Person with
ALL their times. So if 1 person did 20 shifts a month, I don't want to
send them twenty emails with every single individuals shift, but
rather I want to send them 1 email with all two shifts in the email.

 

[Burning_Ranger]

No, you currently don't have the correct format of your csv-file then. It
needs to be formatted with the following columns for that to work;
Name | Email | Time1 | Time2 | Time 3

In that case is it possible to automate this from the format I have?

 

[Roady [MVP]]

I'm no Excel expert but I think you can indeed rearrange it or create a new
Excel sheet with the first one as the source. In a database solution it
should be even easier. Check in a support newsgroup for the solution you
want to use to maintain your csv-file/data.