Community Discussions and Support
Trying to use mail merge with an excel document

[quote user="blm03"]I'm not getting an error message at all.  I says it is sending it.  However, the mail is not showing up in the Gmail account.  It did show up in the SBC Yahoo account, so I know it worked.
[/quote] If there is no message at all then you are probably getting caught in some sort of spam trap.  Also there is nothing that can be done to really help you either without something to work with.

 

<p>[quote user="blm03"]I'm not getting an error message at all.  I says it is sending it.  However, the mail is not showing up in the Gmail account.  It did show up in the SBC Yahoo account, so I know it worked. [/quote] If there is no message at all then you are probably getting caught in some sort of spam trap.  Also there is nothing that can be done to really help you either without something to work with.</p><p> </p>

I have an excel document that has a list of names and email (column 1 has the names and column 2 has the emails).  I am trying to use mail merge so it pulls the emails and the names, so I can send them all the same message.  However, I cannot figure out how to do it.  (I would use the "help", but I am on Vista and that doesn't work.)  Any suggestions would be greatly appreciated!

I have an excel document that has a list of names and email (column 1 has the names and column 2 has the emails).  I am trying to use mail merge so it pulls the emails and the names, so I can send them all the same message.  However, I cannot figure out how to do it.  (I would use the "help", but I am on Vista and that doesn't work.)  Any suggestions would be greatly appreciated!

Export the Excel spreadsheet to a CSV file using either Comma or Tab as the separator.

 Then in Pegasus Mail Mail-Merge follow the steps, telling Mail-merge the data file name and which column has the email address (in your data file this is Column 2).  You then build a template message, adding the column number for the Names, in the format ~n  where n is the column in your data file ie ~1.

then just follow the remaining steps in mail-merge

HTH

Martin 

<p>Export the Excel spreadsheet to a CSV file using either Comma or Tab as the separator.</p><p> Then in Pegasus Mail Mail-Merge follow the steps, telling Mail-merge the data file name and which column has the email address (in your data file this is Column 2).  You then build a template message, adding the column number for the Names, in the format ~n  where n is the column in your data file ie ~1.</p><p>then just follow the remaining steps in mail-merge</p><p>HTH</p><p>Martin </p>

Thanks!!!  I got it to work.  However, it is not sending the message to the Gmail accounts.  Any fix for that?

Thanks!!!  I got it to work.  However, it is not sending the message to the Gmail accounts.  Any fix for that?

[quote user="blm03"]Thanks!!!  I got it to work.  However, it is not sending the message to the Gmail accounts.  Any fix for that?
[/quote]

What's the error message?  I send mail merge to GMail accounts without problem.

 

<p>[quote user="blm03"]Thanks!!!  I got it to work.  However, it is not sending the message to the Gmail accounts.  Any fix for that? [/quote] What's the error message?  I send mail merge to GMail accounts without problem.</p><p> </p>

I'm not getting an error message at all.  I says it is sending it.  However, the mail is not showing up in the Gmail account.  It did show up in the SBC Yahoo account, so I know it worked.

I'm not getting an error message at all.  I says it is sending it.  However, the mail is not showing up in the Gmail account.  It did show up in the SBC Yahoo account, so I know it worked.
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft