Email Merge With Delay

macropod · #1 02-07-2021, 02:48 PM

Open you workbook and press Ctrl-End. If the row selected is below your last data row, your mailmerge data don't include valid email addresses for all records. You need to explicitly delete the unused rows and re-save the workbook.

RNanfro · #2 02-07-2021, 03:00 PM

Hi Paul,
Tried the CTRL-End and it took me to the last record of the five. Still the same problem of the error message and the macro stopping before the Call Pause delay. Debug shows the line highlighted below.

Code:

            .Execute Pause:=False
        End With
        Call Pause(10)

Thanks,
Rob

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Catalogue Email Merge with Delay Between Messages	Berryblue67	Mail Merge	11	02-23-2018 01:28 PM
Email alert delay (driving me mad)	alexb123	Outlook	1	07-18-2014 02:35 AM
Delay email to one person in a distribution list	dixiesstar	Outlook	0	09-13-2012 01:56 PM
delay sending email and follow up on all emails	lefteris	Outlook	1	05-17-2011 05:11 PM
Email send delay--where?	markg2	Outlook	8	02-14-2010 03:40 PM